Is there a way to rename the mdf and ldf files associated with a databse. Also can I rename the fil nemae that is created for these when the databse gets created....more >>

I have a sql linked server pointed to a cache database. I created it using the oledb for odbc and pointed it to an odbc data source I created using the intersystems odbc driver install. I can openquery the database fine if i need to pull back specific record fine. But if i try to join data betwe...more >>

Hi I wonder if there is a trick I can use to debug what was changed in my database (mssql2000). The idea maybe sound stupid but my boss have got old console application which is doing some changes in database (only in data in tables rather:). I have no code for that application and we are ...more >>

Im seeing an average of 4-5 compilations/sec with max at 60s and 70s at times. But the recompilations/sec could average around 0 or 1.. How can i find out what sprocs are triggering the compiles ?And why would they ? I tried to look at sysprocesses at the waitresource column for values tha...more >>

Can you have Databse names that contain spaces such as Intanet Content Databse? Will this cause any issues in SQL 2000?...more >>

We just upgraded SQL Server 7.0 databases to 2005. Backed up 7.0 database and restored in 2005 Server. when we migrating the data from new sql server 2005 database(that is just converted) to spred sheet we are getiing an error messages "can not convert nicode and nonunicode string datatypes....more >>

We just migrated SQL Servver 7.0 tables to SQL Server 2005. When we try to export the data of one table to spred sheet we are getting these error messages "can not convert nicode and nonunicode string datatypes. I verified the sort order in 7.0 is 52 and 2005 also 52. any one any idia what ...more >>

I have an error message of connecting to a SQL Server 2005 from SQL Server 7.0. I tried to set up a linked server connection from SQL Server 2000 and it works fine. It not working on SQL Server 7.0. Is there a restriction of connecting to SQL Server 2005 from 7.0? Thanks! Error Message:...more >>

All, Have a deadlock issue - see 1204 trace info below. After reviewing BOL I cannot ascertain the exact resource (table, page, index, etc) that is causing the deadlock. I believe it might be a row in a table (ie - RID: 2:1:81:0 and RID: 2:1:81:1) but I am suspicious about this and I cann...more >>

I've been shipping logs to a warm standby server and now wish to switch to this server in order to perform maintenance on the primary server. (Both are running SQL Server 2000 Standard Edition). I intend to take the primary server offline, and rename the standby server so all clients on t...more >>

Hi All, I am having this strange behaviour on couple of our database servers. Our system crashed and it got rebooted, but SQLServer hangs forever and its status of service is always "Starting". After seeing this we try to reboot the system, but same thing happens again and again. On...more >>

Hi, I have SQL 2000 and SQL 2005 both installed on the same machine. I'm trying to migrate a SQL2K database to my SQL2005 server using the Copy Database Wizard. Every time, it fails on the Create Package step with a message that it has no additional information for the specific error (yea...more >>

Is there any solution? Do you know some and would like to share? Please Tom ...more >>