|
Posted by Erland Sommarskog on 01/09/08 22:40
Crazy Cat (danbredy@hotmail.com) writes:
> Why in the hell doesn't SQL Server provide a facility for dropping an
> active connection on an attached database in SQL Server Management
> console? I can't detach an attached database because apparently there
> is an active connection.
ALTER DATABASE db SET SINGLE_USER WITH ROLLBACK IMMEDIATE
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|