PHWinfo - Afficher un message - SQL2005: running tsql commands in single-user mode

20/12/2007, 23h15

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/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

20/12/2007, 23h15	#3
Erland Sommarskog Messages: n/a Hébergeur:	Re: SQL2005: Running TSQL commands in single-user mode 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/pro...ads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinf...ons/books.mspx