Posted by Erland Sommarskog on 12/20/07 22:15

Plamen Ratchev (Plamen@SQLStudio.com) writes:
> 2). Use sp_who to find the session ID of the active connection and use
> KILL to terminate it.

Kind of difficult when Mike can't connect...

> 3). If all fails you can open a dedicated administrator connection:
> http://msdn2.microsoft.com/en-us/library/ms189595.aspx

Using the DAC definitely seems to be the best bet in this case. Mike
already has the server in single-user mode.

I am glad to see that you finally got the startup options working, Mike.


--
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

• Next in forum: Re: Loose ODBC conection
• Prev in forum: Re: Setting up a store procedure...
• Thread view: Re: SQL2005: Running TSQL commands in single-user mode

[Reply to this message]