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
 General SQL Server Forums
 New to SQL Server Administration
 alter database

Author  Topic 

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2011-06-13 : 05:24:58
hello everybody,
iam trying to set my database to single user mode..
but when i execute the command it is going on processing..
what might be the reason...
thnks in advance

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-06-13 : 06:11:06
There's existing connections to the DB. The command has to wait until those all close if it wasn't specified with one of the ROLLBACK options.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -