Posted by Crazy Cat on 09/30/15 12:00

On Jan 9, 5:40 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> Crazy Cat (danbr...@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, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Thanks Erland, I'll give it a try.

You are the man!

Crazy

[Back to original message]