Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Database set to single-user

Author  Topic 

deparker
Starting Member

1 Post

Posted - 2008-12-11 : 05:53:50
Can anyone assist? We have a situation where a customer's SQL Server 2000 database is being set to single user overnight with no manual intervention. Is this possible and does anyone know how this could happen? We have run CHECKDB and it has not identified any errors.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-12-11 : 09:57:15
It should be logged in SQL Server Log. Trace with profiler.
Go to Top of Page
   

- Advertisement -