Answer Questions

• js123 Installing SQL Server Express 2005

  I'm not able to remove previous version of SQL Server Express 2005 (CTP). It is listed under "Add or Remove Programs", but without REMOVE button. I tried to remove it before, but unsucessfully. As result, I can't install release version that comes with the Visual Studio 2005 Pro. Here is the last *_Core.log from C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files: Microsoft SQL Server 2005 Setup beginning at Fri Nov 18 21:29:08 ...Show All

• Gadget_IOM DTS2000 error

  Hi When I try to use DTS 2000 Packages in SQL2005 CTP I obtain this error: Could not load file or assembly 'Microsoft.SqlServer.Dts80, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. Impossibile trovare il file specificato. (Microsoft.SqlServer.DtsObjectExplorerUI) Anyone can help me Thanks Which CTP version are you using Look in your DTS\binn folder (by default this is at "C:\program file ...Show All

• Dan Harris raw file destination and environment variables

  when using a raw file destination it would be nice to be able to use an environment variable for the filename property. like %my_extract%\data.txt instead of c:\my_extract\data.txt not working for me. so you actually ran it. it worked seriously you actually ran it and it created the file you specified I create the variable at the package level. I create the script task and stick t ...Show All

• Ju Wu selecting colunm with a space ''

  When I submit a sql : select * from view from column='' the table is a view point to oracle table with ole db provider for oracle In mssql2000, the result return rows which containing a space ' ' However, in mssql2005, the result return no rows . Any advise on it in remote view in MSSQL2000, '' treats as a space ' ' but mssql2005  is different how can i define '' as a space in sql2k5 as in ...Show All

• Jeff Waz Installing Microsoft SQL Server 2005 9.00.1399.06

  I'm having problem with installing Microsoft SQL Server 2005 9.00.1399.06. I have (I think removed) all beta and other SQL files but the installation still fails. Any ideas on where to look for the problem(s) summary.txt looks like this: Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version      : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time      ...Show All

• Greg3055 Need distributed service broker sample

  I'm working with the April CTP of SQL Server and I'm trying to create a proof of concept using service broker.  I'm struggling with the "abc's" of it.  If anyone has or can point me to a distributed "Hello, World" for service broker between SQL Server 2005 and SQL Express instances it would save me some time and trouble. thx!   Christopher Yager wrote: I'm working with the April CTP of SQL ...Show All

• IsoKake stay password in connection string

  Hi after connect to SQL database from .NET the password is removed from connection string, what can i do for stay it in connection string thank you Use the 'Persist Security Info' keyword and set it to true, for example: "Persist Security Info=True;User Id=mysuser;Password=mypassword;database=northwind;server=mySQLServer" ...Show All

• Karen Gayda re-establishing mirror

  When witness and mirror were down, mirroring was removed at primary. Now when I try to re-establish mirroring I get the following error Msg 1456, Level 16, State 3, Line 1 The ALTER DATABASE command could not be sent to the remote server instance 'TCP://witness:5022'. The database mirroring configuration was not changed. Verify that the server is connected, and try again. On the witness server the following sql select * from sys.databas ...Show All

• mrpatel Using CLR Stored Procedure for Data Driven Subscription

  This is a stumper: I have a .NET stored procedure that returns email addresses, and I want to use it for a data driven subscription (DDS) for a report. The 'email' field returned is not exposed to the DDS wizards so if I set 'exec myCLR_SP' as the query for the data the 'email' field is not in the drop down list of available query derived values. So my question: Is their anyway to imform the DDS wizard that the myCLR_SP returns a field called 'e ...Show All

• poliveira loosing values when load from text file

  When loading a table in a data flow from a text file that contains non-null float values, I am seeing erratic and inconsistent results.  I am presently using SQL Server Destination in a data flow. - With low volumnes of data, less that 50,000 rows, no problems - But with higher volumnes, 2,000,000+ rows, I get different results depending on how I run the package.  If I run is directly (right-click and cli ...Show All

• StoneTao Script component as Destination - HasSideEffects?

  How to set 'HasSideEffects' property for any input column of a script component used as destination My Script component reads input, generates SQL update statements dynamically and fires them. There is no output. When executing, I get this error (which is self-explanatory). "Script Component" (1573) has been removed from the Data Flow task because its output is not used and its inputs have no side effects. If the component is required, then t ...Show All

• Paul.Prasanta Returns Nothing, But Executes Fine

  SELECT tblWatchInstance.WatchID,tblWatchBrands.Description,tblWatches.Serial_Number,tblWatches.OwnerFName,tblWatches.OwnerLName, tblClients.Name FROM tblWatchInstance INNER JOIN tblWatches ON tblWatchInstance.Watch_Key = tblWatches.WATCH_KEY INNER JOIN tblWatchColors ON tblWatches.COLOR_KEY = tblWatchColors.COLOR_KEY INNER JOIN tblWatchBrands ON tblWatches.BRAND_KEY = tblWatchBrands.BRAND_KEY INNER JOIN tblWatchTypes ON tblWatches.WATCHTYPE_KEY ...Show All

• leemcd Connection Issues

  Hi, I have sql express server running on a network pc. I have created an application on the same pc that is able to access the data contained within the sql express server. I have depolyed the application to another network pc, but it is not able to access the same data. I have also installed 'ssmse', this cant connect to the database either I have enabled the TCP/IP Protocol on the server, enabled the browser service, disabled the fire ...Show All

• hrubesh System.Web.Services.Protocols.SoapException

  I am running VS Team Suite, and did a fresh installation of SQL Server 2005. When I try to deploy the sample reports, build was successful. However, when I try to deploy it, I got the following error: System.Web.Services.Protocols.SoapException: Server was unable to process request, ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebCon ...Show All

• Randy D. Smith SSIS error message when trying to open MSDB in management studio

  Hi all, I get this error when trying to open folder MSDB in management studio. I'm running Win 2003, SQL server 2005 64 bit on AMD with two instances of SQL. Any one that have a solution I havent found any thing that works. If I enable VIA in SQL Server I can't start SQL Service TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For ...Show All