Answer Questions

• davidg12 SQL Server 2005 Data Compare

  Hi We are upgrading to 2005 version and I am looking to see if SQL Server 2005 version has anything built into it like Red Gates SQL Data Compare Tool. I couldnt find anything thus far that shows 2005 version having anything like this so I thought I would ask to make sure. Thanks so much! Stokh There is a command line utility included in SQL Server 2005 (tablediff.exe). Hth WesleyB Visit my SQL Server weblog @ http ...Show All

• Brett Riley Login failed

  I have VS2005 Beta 2 I created a very simple Web Site that has a Login page and a Default Page I installed MSDE so that I can use a SQL 2000 database I ran C:\WINDOWS\Microsoft.NET\Framework\v2.0.50215\aspnet_regsql.exe to create a database in the MSSQLSERVER for user info. My Web.config file looks like: < xml version = " 1.0 " > < configuration xmlns = " http://schemas.microsoft.com/.NetConfiguration/v2.0 " > < appSettin ...Show All

• ray fitzh how to synchronize between sql mobile 2005 & sql 2000?

  Hi, I need to synchronize a sql mobile database & sql 2000 database. Someone knows how can I export a SQL 2000 db to SQL mobile 2005 (.sdf) Cesar! Please see topic " Managing Connectivity (SQL Server Mobile) " at http://msdn2.microsoft.com/en-us/library/ms171801(en-US,SQL.90).aspx .   Thk Greg, but do u mean what can not I  use SQL 2000 & SQL 2005 mobile look,  I did ...Show All

• david7520 Separate date and time datatypes - come on guys!

  Oh for crying out loud, how come there aren't separate date and time datatypes in SQL 2005!   I know for a fact that this feature has been requested for YEARS!!!!  Thanks for giving me the YAGNI feature of renaming my menu items in SQL Management Studio.  I guess that was somehow a higher priority than a time datatype. I just want to say  bravo to BAnVA and give him my ...Show All

• thomas.gauchet EMail Notifications

  Yukon Apr '05 CTP Using Notification Services Trying to send out notifications by mail Entry in the instanceconfig file   <DeliveryChannel>       <DeliveryChannelName>MailChannel</DeliveryChannelName>      <ProtocolName>SMTP</ProtocolName>       <Arguments>        <Argument>     ...Show All

• Javier_Mexico Certificate not recognized by SQL 2005 - Encryption Problem

  Hi, We recently upgraded from SQL 2K to SQL 2005 on WINDOWS 2003 Server. The entire upgrade process has run pretty smoothly aside from encryption. We have ASP.NET 1.x apps that connect to an internal server but fail when encrypted. We have tried all of the steps available on the MS KB and still have not resolved the issue. On http://msdn2.microsoft.com/en-us/library/ms191192.aspx, we find the following: To configure the server to accept encrypte ...Show All

• Charleh How to invoke C# code from SSIS? Can we script in C# for Script Task?

  How to invoke C# code from SSIS Can we script in C# for Script Task thanks There is no big problem "developing some code in VB.net" on the surface, but since the the original poster wanted to use C# over VB.Net, as the title and posts indicates. So this is a problem for them in so much as the answer for them is no, as you can only use VB.Net which is not what they wanted. I've seen the responses to why SSIS Scripts don't ...Show All

• Julian Ladbury MSDE SP4 install problem

  I attempted to install MSDE SP4 (file SQL2000.MSDE-KB884525-SP4-x86-ENU) on a WinXP Pro SP2 machine. Command used: setup SAPWD="ourpw" SECURITYMODE=SQL /L*v c:\MSDELog.log Install log shows successful install. MSDE appears to function properly, service starts automatically after reboot, etc. I can open and work with DB's with a freebie 3rd party GUI called DbaMGR2K, through which I have added the necessary DB user for ou ...Show All

• Carlitos Using Custom Classes

  Hi ! Currently we have over 500 reports working with reportserver. We're planning to add on our report hyperlink to some pages of our web application. What i want is to have a classe with a function that will return a string for the action to do on the "Jump to URL" function. The reason why i need to use a classe is because if we change the name of a page we dont want to modify all the report one by one. Also we have some client ...Show All

• DuckPuppy Target Not updated while looping through Source files to load

  I have a SSIS package which has a ForEach loop with ADO records. The record set is loaded with the Source files name. When the loops runs first time it updates my staging area and loads data in to the DIM and Fact tables. In the second time it loops(for second source file) it shows me the data in the grid (i have) before writing to the StageTables but it does not write any records to the table so it did not update my Facts for the second s ...Show All

• L_M Excel Browser error

  Hi I'm trying to browse a cube using excel. I get through the pivot table wizrd ok but when I click finish I am getting the following error: XML for Analysis parser: The localeidentifier property is not overwritable and cannot be assigned a new value I get the message regardless of whether I am trying to connect to my own cubes or the Adventure Works sample. Any idea of cause & remedy please Thanks Wayne ...Show All

• Dmitry Vorobyev How to achieve the last Time-selection while iterating in the time-dimension itself ?

  Hello I try to explain my problem with an example: Page-filter Fields: &[Year 2003].&[Jan].&[3], &[Year 2003].&[Jan].&[4], &[Year 2003].&[Jan].&[5] (=Multiple Item Selections) Range in days = 3 days Behind the scene: [ ] [Mutation] Year 2003 Q1 Jan 1 2 3 3 (=DayRange-1+1) 5 4 2 (=DayRange-2+1) -2 ...Show All

• abasilis Copying Database without data

  Hi, Does anyone know, with either the Apr or Jun CTP, how to copy an entire database without the data   I know to use the SSIS wizard to copy tables with data, but there seem to be no option to not copy the data. Thanks. In the June CTP you can use the Transfer Objects Task. It has an option for transferring data that you may set to false. BTW, There are some issues with this task in the June CT ...Show All

• Bassam Basamad Variables in the four naming conventions

  Hi I am running SQL Server 2000 and have two different databases with different names on two different machines. The servers (machines) are linked and I want to use a single set of stored procedures on both databases. I want to know if and how I can use variables in the four naming conventions in a stored procedure. This way I do not have to write an if statement and rewrite the code for each database. Example: Select * from SE ...Show All

• arch_angel81 compatibility question

  just a question.... my web project is using SQL Express2005 and ASP.NET and C#. my web hosting company only have MSsql2000. would there be any conflict with regards to my database im sorry if i sound dumb. im a newbie to this. thanks a lot! It depends. Are you using user instances(its in the connection string) are you using varchar(max), xml types Are you using the new security features Any of the ...Show All