Answer Questions

• GregRyanLorenz Cumulative Hotfix Package - Build 2153

  I'm getting ready to install the Cumulative Hotfix Package - Build 2153 on a 2-node, Active/Passive cluster (MSSQL 2005 EE on Windows 2003). I've read through the docs a number of times but don't see any reference to clustering. Should I apply the hotfixes to each node or are the fixes cluster-aware Thanks. I also have a 2-node Active/Passive cluster (MSSQL 2005 64-bit on Windows 2003). I would like to apply the cumulative hotfix, but I too have not found any documentation specific to a clustered installation. Did you install the hotfix on your cluster If yes, did you have any issues ...Show All

• Coolkid Security Issues with Reports

  I am having a problem with getting my reports to work after deploying them to a report server.  Viewing them in the preview pane in Visual Studio 2005 works fine with the data being returned. But when trying to navigate to the report from my desktop machine using the report server url I get the following error An error has occurred during report processing. Cannot create a connection to data source 'datasource'. For more information about this error navigate to the report server on the local server machine, or enable remote errors So I remote into the report server and browse to the report from there and it works fine and the data is returned.  Is there something I am overlooking here I am using "Window ...Show All

• m.dawood passing a timestamp datatype column to a variable and back

  After several hours of trying, I trow the towel in the ring and come here to ask a question. Source system uses a timestamp column in the transaction tables. which is equal to a non-nullable binary(8) datatype (sql 2000 bol). What I want to do is get the timestamp at the start of the transfer and at the end of the transfer of data. and store these in a controltable I try to do this in 2 sql execute tasks: sqltask 1: "select @@DBTS AS SourceTimestamp" and map the resultset to a variable. Here come's the first problem what variable type to take DBNULL works (meaning it doesn't give errors) (BTW: is there a way to put a variable as a watch when debugging sql tasks ) INT64 and UINT64 don't work error message that t ...Show All

• fdc2005 PIVOT sql_variant into underlying dataypes

  Does anyone know of a way to PIVOT an sql_variant column so that the resulting columns will be their proper underlying datatypes I wish this to be done in a View. I currently do this by hard coding the conversion as follows: SELECT A, B, C MAX(CASE Letters WHEN 'D' THEN CONVERT(int, LetterValue) ELSE Null END AS D, MAX(CASE Letters WHEN 'E' THEN CONVERT(datetime, LetterValue) ELSE Null END AS E, MAX(CASE Letters WHEN 'F' THEN CONVERT(varchar, LetterValue) ELSE Null END AS F FROM Alphabet GROUP BY A, B, C I would like to take advantage of the SQL_VARINIANT_PROPERTY(LetterValue, 'BaseType') function so I do away with the hard coding. Any ideas Thanks for your input. ...Show All

• Ravi Sharma SQL 2000 and 2005 side by side

  I was running sql 2000 for months before the release of sql 2005. I cannot upgrade any old databases on my test server but new applications are to be designed for sql 2005 database. I installed sql 2005 onto my server but for some reason I cannot get the enterpise manager to start (when I doubleclick C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe the splash screen displays for a fraction of a second and disappears). Can I run 2000 and 2005 side by side How can I get the enterprise manager to start Ackim It will be a problem in having 2 SQL versions client tools, you will not be able to open SQL EM when SQL 2005 is installed (server side). You migth try installing S ...Show All

• Mat1t Guidelines for creating a database snapshot on a mirror database

  Hi guys, can I know the steps on creating a database snapshot on a mirror database Thx for the assistance. :) Best Regards, Hans Refer to http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx for more information in this regard. ...Show All

• F.Costa Losing config file between child packages and *$##@!- Passwords!

  I have a parent package that uses Execute Package Task against three child packages. They are all setup to use the same configuration file, and the packages are all located in the same folder. Purpose of the configuation is to use the same connection strings for each child package. I removed the path from the config. file specification to facilitate deployment. During debugging, the child packages cannot find the config file when they are run via the parent unless the full path is specified. If run standalone, a child package can find the config. file without the path. As I said, all dtsx filaes and the config file is in the same folder. Also, the password-removal issue is killing me in development. Everytime I touch the config. f ...Show All

• Saibal Goswami Make subtotal column widths bigger than normal columns?

  The reason I say this is because a subtotal of a dollar amount will take up more space than other values. Right now, I'm forced to make all columns the same larger width because it appears to be all wrapped into 1 column width setting. I can try to change the value of the subtotal column, "matrixcolumn4", but it reverts to the other value after I press enter to apply the changes. Sorry there is no good solution at this point. One alternative approach is to use side-by-side matrices to a subtotal column with different width, however you would need to "hide" the row headers of the second matrix. For the next major SSRS release we are looking into significantly improved support of thes ...Show All

• okidoki BIDS and SSMS very slow on Windows XP SP2

  Hi, opening SQL Server Management Studio 2005 or Business Intelligence Development Studio 2005 on my Windows XP SP2 Professional Edition is extremely slow. Espacially in BIDS it take several seconds for each action. Is anybody aware of this problem We didn't have those problems on Win2000 so I guess it is XP related. Any ideas Regards Norbert Bender I added the /nosplash option but it didn't change anything. It is still very slow. Any other idea Regards Norbert Thanks for the hints. I checked the permissions for the account and they can access the internet, so I guess, this isn't the solution. My client has has 1 GB to as RAM and ususally I do ...Show All

• Busywolf Views not working well

  After designing a new system totally within SQL 2005 Management Server, i find the application a bit buggy. 1) When trying to return the tables and columns on the current database, I created a view below. I had it simply sort by table name, and row name. Executing the view inside of the design mode works fine. opening up the view and it fails. SELECT TOP (100) PERCENT TABLE_NAME AS Name, COLUMN_NAME, COLUMN_DEFAULT, DATA_TYPE, NUMERIC_PRECISION, NUMERIC_SCALE, TABLE_CATALOG FROM INFORMATION_SCHEMA.COLUMNS ORDER BY Name, COLUMN_NAME 2) Open up any table, show diagram, sql , criteria panes. Select any field displayed in the diagram table, output should be checked, the sort ascending on it, then uncheck the output ...Show All

• praveench2k confident of data mining

  in associate rule, there's confident and support or probabilty values. but i use sql 2000, no support associate rule so i create a model with Microsoft _decision _tree to predict other products when customer choose product in superMarket basket_id table... { productid } is it have confident or support values. what value of it how can i change the minimum_support and minimum_probabilty it can use in Microsoft _ decision tree. I believe the default is 10. You can set parameters using the advanced properties of the mining model in the designer. Alternatively, I wrote (a long time ago) an addin for Analysis Manager that provides a UI for setting parameters in SQL 2000 data mining similar ...Show All

• bruce2005 SQLDiag on 2005 64bit

  Hi All, I am working on a performance issue on SQL Server 2005 Ent. SP1 x64-bit cluster. I am lack of available tools I used on 2000. How do you handle performance issues on 2005 64-bit PSSDIAG : not supported SQLDIAG on 2005 x64: giving me an error and I cant find sqldiag.xml file. C:\Program Files\Microsoft SQL Server\90\Tools\Binn>sqldiag /O J:\PSS\ /B 200612 20_132100 /E 20061220_132300 2006/12/20 13:21:27.98 SQLDIAG Error creating script file . Function result: 2. Message: The system cannot find the file specified. 2006/12/20 13:21:27.98 SQLDIAG Error unpacking files. Aborting Read80Trace: not supported Blocker script: Thanks, Ada Performance issues ...Show All

• Nigel Hamer missing tables

  I have a database that I have been working on that is on a remote server for a website. I recently had them back up the database so I can work on it locally. After some time I managed to get the backup working, well sorta. Originally the database was a access 2000 database. This soon proved not to be up to the task. The server people converted the database to sql 2000 and everything is working on the site. However my backup has a problem. In the manager I can see all the tables that were there before. But when I go to run a query on the database through CF the only tables that it can see are tables that were created after the access conversion. I have gone in and checked permissions and set every table and every column to public and still ...Show All

• ETor Safe to kill CPU process sqlmaint.exe?

  Q: Is it safe to kill the CPU process "sqlmaint.exe" after shutting down SQL server I am running SQL 2000 Enterprise Sp4, on Windows NT server. I have a few old maintenance jobs under SQL Agent Jobs whose status have been hung at "Executing" forever. I killed the process spid within Enterprise Manager. Using sp_who, I can see the status of all 11 jobs has changed to "killed/rollback". I shut down SQL server and opened the Windows NT task manager. I observed several instances of "sqlmaint.exe". Within a few minutes, all but three of them were gone. So, is it safe to "end the process" using windows Task Manager for the remaining sqlmaint.exe processes ...Show All

• PedroSimao Default char value in import

  Hi yall, Is there a way to change the default char value from (50) on an import, in this case from a flat file It is a daily import so changing the field each time is time consuming and difficult to implement to non-saavy users. Thank you! ...Show All