Home All Groups Group Topic Archive Search About

SQL Server Tools

microsoft.public.sqlserver.tools
Score Combination of English and Chinese characters in Microsoft SQLServer 2000
newsqlserveruser - 17 Nov 2006 6:54 AM - 7 messages
Hello, We have Microsoft SQL Server 2000 with Service Pack 3a installed. In one of our databases, we have a table REQ with one of the fields COMMENT being defined as TEXT. Now, when we try to view the COMMENT ...
Score Fail to save Maintenace Plan using 'sa' with blank password
Michael Bergman - 16 Nov 2006 6:30 PM - 3 messages
Is it not supported to create a Maintenance Plan when logged in as 'sa' with blank password in SQL Server Management Studio? When logged in as 'sa' I get the following error when trying to save a Maintenance Plan: One or more arguments are invalid ...
Score DBCC shrinkdatabase
news.microsoft.com - 16 Nov 2006 12:59 PM - 3 messages
Hi All I am currently in a catch 22 situation. I need to shrink my database before i can back it up ( as the time it takes to back up now has gone over the time allocate to the backup process) . ...
Score Install SQL 2005 Report Service on SQL 2000 Server
Wing - 16 Nov 2006 8:49 AM - 1 message
Dear ALL, Anyone has experience to install SQL 2005 Report Service on a SQL 2000 Server?? Thanks, Wing ...
Score Tuning Wizard cannot find SP
Otis Bricker - 15 Nov 2006 5:16 PM - 5 messages
After capturing some activity into a profile using the SQL2005 Profiler, The database Tuning wizard seems to be unable to locate one and only one of the stored Procedures that was called and gives me an E001 error/warning. I have tried recreating the SP it still reports it missing. Since it was ...
Score Updates/Changes Log
David Saunders - 15 Nov 2006 4:28 PM - 3 messages
Hi I am interested in seeing all upgrades and change made to a SQL 2000 database. Are there are any logs kept in SQL 2000 that tell you all of the changes and upgrades made to the DB since installation? ...
Score Help!! - SQL 2005 Profiler - RPC:Completed event and TextData colu
bill k. - 15 Nov 2006 12:52 AM - 1 message
Hi, Botton line is I want to be able to see TextData column with RPC:Completed event. from SQL 2005 Profiler 1. connect to SQL server 2. Add Stored Procedures - RPC:Completed event 3. Add TextData column and SPID column ...
Score Createing a DB with osql - passing in the DB name and user rights
David Thielen - 14 Nov 2006 11:33 PM - 3 messages
Hi; I have a .sql file that creates a database fine. I have two questions on this: 1) Is there a way to set the name of the database I am going to create dynamically? This will ship with our install program and it the installer ...
Score What does this mean?
David Thielen - 14 Nov 2006 11:33 PM - 6 messages
I'm creating a database with osql and getting the message: 1> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> Warning: The table ...
Score 2005 MS Options
jw56578@gmail.com - 14 Nov 2006 11:02 PM - 2 messages
is there a way to display the size in bytes of the results from a query in management studio? ...
Score Upgrade connection issues
Peter Lux - 14 Nov 2006 6:07 PM - 5 messages
We're running Great Plains and just converted to 9 from 7.5 which included a conversion of SqlServer 2000 to 2005. I'm having an issue with users in that 2005 now encrypts and we imported the users and they periodically get a ...
Score Error 0: Cannot load the DLL xpstar.dll, or one of the DLL it references. Reason 126(The specified m
jpencola - 14 Nov 2006 3:29 PM - 1 message
I ahve tried some of the posts I ahve seen to fix this but I cannot reregister the xpstar file and I do not have another SQL xpstar file I can copy from, can someone give some details on how to correct this ...
Score From access to SQLServer 2005
Santiago Torras - 13 Nov 2006 9:42 PM - 1 message
I am trying to import an Access DB to SQLServer 2005, using the Microsoft SQL Server migration assistant for access but when converting the schema it complains constantly about "Nullable" fields. The result is that, in the newly created  SQL Server database all tables are invalid. ...
Score Performance Tools
eladla - 13 Nov 2006 2:46 PM - 3 messages
I want to profile my database, but can`t find the performance tools anywhere. I tried installing it from the CD, but can`t find it in any of the installation options. How do I install these tools? ...
Score DaVinci Toolset
hurricane51 - 13 Nov 2006 3:18 AM - 3 messages
How do I obtain the DaVinci toolset for SQL Server? I've seen many references to them but none of them mention how to obtain them, or whether they are included in SQL Server, etc. Where are they located? ...
Score creating a database
David Thielen - 12 Nov 2006 10:32 PM - 7 messages
Hi; If I have a schema for creating a database, is there a command line application I can run and pass it the filename of the schema and it will then create that database? If so, can someone point me to a url showing the ...
Score View results of Dynamic SQL in Management Studio
amanda - 12 Nov 2006 11:41 AM - 6 messages
Hi, I would like to know how to view the results of a dynamic sql query in Management Studio.  This is from my stored procedure: select @sql = 'SELECT IR.IDInspectionResult FROM dbo.MeasurePosition MPos INNER JOIN dbo.MeasurePoint MP ON MP.FKMeasurePosition = ...
Score VSS and SQL servers
Infomax - 12 Nov 2006 1:29 AM - 2 messages
If SQL 2000/2005 is running on a Windows 2003 Server (SP1) and I run a full backup using NTBackup weekly, does VSS backup the SQL databases through this full backup? Thanks, Ted ...
Next »