Viewing 15 posts - 931 through 945 (of 1,248 total)
Just for curiosity.
Is it possible to set the compatibility to 80 in SQL Server 2005, then backup, then restore the backup to SQL 2000?
I have not tested, yet.
June 4, 2007 at 8:55 am
Just my input.
If an spid can execute more than one transaction, it is not weird that a deadlock is created by one spid since two transactions can lock each other.
To...
June 4, 2007 at 8:50 am
From my personal of pointview, it is most likely the connections exceeded the maximum number of connections allowed to the database. The error message occurs when using JDBC and ODBC....
June 1, 2007 at 8:59 am
Did you change the startup parameter in the SQL Server Properties dialog?
May 31, 2007 at 8:33 am
You may try the following:
Stop your SQL Server service.
Overwrite existing msdb by your msdb2.
Rename your file names.
Re-start your SQL Server service.
May 31, 2007 at 8:25 am
One thought.
It seems to me that you have SQL Server client installed on your machine. Did you check the versions of the SQL Server and your SQL Server client tools?...
May 31, 2007 at 8:15 am
In my previous message, I missed the part, 'Update_one'.
I tried 'Auto_Fix', but it was no good.
May 29, 2007 at 12:09 pm
I would like to say your restore broke the relationship between users and logins (orphan users). You may run the following script to see if your login is in the...
May 24, 2007 at 8:00 am
It is an interesting problem. I would like to check if there is any other process running against this server. For example, some people create temp tables and never drop...
May 22, 2007 at 8:24 am
If one of drives fails, your system will become very slow.
May 18, 2007 at 8:02 am
How did you install your SQL Server?
Remote install? If so, you may not be able to change paths.
Mapping drive? If so, you can change paths.
Others? No clue at this moment.
May 15, 2007 at 8:50 am
Here is a link, which may be helpful for the SQLAgent management.
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6645
May 11, 2007 at 8:54 am
There were many discussions on this topic in this forum. Most likely, the order of your differential backups is not correct. Here are two links. May they helpful.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=143564
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=308260
May 11, 2007 at 7:45 am
You can run the following stored procedure to recycle your error logs.
EXEC sp_cycle_errorlog
May 9, 2007 at 1:26 pm
It is incorrect, at least in SQL Server 2000. In SQL Server, DENY has higher priority over other roles. DENY overwrites other roles even for db_owner. But DENY would not...
May 9, 2007 at 1:18 pm
Viewing 15 posts - 931 through 945 (of 1,248 total)