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.

I know you can use SSEUTIL but it seems like kluge for a poorly
thought out function.

Crazy

Crazy Cat (danbredy (AT) hotmail (DOT) com) writes:
ALTER DATABASE db SET SINGLE_USER WITH ROLLBACK IMMEDIATE


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

On Jan 9, 5:40 pm, Erland Sommarskog <esq... (AT) sommarskog (DOT) se> wrote:
Thanks Erland, I'll give it a try.

You are the man!

Crazy