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@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/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...@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