I have SQL Server 2000 set up using port #1433, when I try to create DSN to connect to this server, I got error message "SQL Server does not exist or...
I tried to restore database using T-SQL in SQL SERVER 2000(SP4). When I logged in using a specific user other than sa, I got error "user does not...
Is there any T-SQL I can run to find tables owner after I restore the database to SQL Server? Thanks, kathy
I had a old sql server with collation setting Case Sensitive. After I rebuild this server and change it to case insensitive. I restored all Case...
In sql server 2005, we can use dynamic view dm_exec_requests to query the process status of a database restore. Is there a table or view I can use in...
Hi, I have a backup file on a shared drive. I am trying to restore it to my sql server (sql server 2000 SP4). It always fails. How can I do this...
I installed SQL Server 2000 SP4 (32bit) on Windows 2003 Server 64bit. When using Veritas Backup Exec 10d to backup dbs on sql server, the backup job...
If I only know the database name and a value, is there any command I can know the tablename and column name which contains this value in sql server?...
I am going to set up a new sql server machine. If I set up the new server with all databases, DTS packages and jobs, then I rename the sever name to...
Is anybody using Veritas Backup Exec Utility to do backup job on sql server 2000? I am using Backup Exec Utility 10d, I got errors complaining the...
I create a DTS package, use one connection to create and populate temp table with ids to work with in next step, as following: declare...
The new db is created on the default location (C:programs filesMicrosoft SQL ServerMSQLData when using EM. Now I want to change the default location...
I got "automation error, the specified procedure could not found" when accessing to analysis server. Is anybody have any idea about this error?...
Is there query I can check how many users use one specific database? Thanks, Kathy
I create a new user on the database, try to grant this user permission to execute all store procedures created by dbo. How can I grant permission to...
When I run the query to retriev data from a table, one of column contains info like: hi, I am working, please ..... Is there any way I can split...
Hi, Is there any command that I can use to check the specific table last access time on sql server 2000? Thanks, - kathy
Hi, I have a "testMD.dat". How can I restore this file to the sql server 2000? Thanks, - Kathy
I create the new database and make user as dbo, but the user could not execute store procedure such as sp_lock. Would you please tell me how to grant...
IS there anyway that I can get SQL Server Table DDL from a SQL prompt? Thanks, - Kathy
Separate names with a comma.
