Re: SQL2005: Running TSQL commands in single-user mode

Plamen Ratchev (Plamen@xxxxxxxxxxxxx) 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@xxxxxxxxxxxxx

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
.

Relevant Pages

  • Re: HasChanges returns false for one row, true when more than one
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... "Mike G Burton" wrote in message ... dataset has a single row, but True if the dataset has multiple rows. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: simple collaboration enable ?
    ... Listen to Mike, ignore the monkey trying to figure ... > throttling on more than 5 concurrent connections). ... > c) not restricted to WSS databases only ... > SQL Server 2K) ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: VS 2005 Beta 1 and SQL Server 2005
    ... Hey Mike ... To use the April CTP of SQL Server 2005 you would have to also use the ... correct build of the .NET Framework which would be the official April CTP. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Database events - notify an application
    ... of sql server was an extended stored procedure. ... Mike ... > You could look at Notification Services: ...
    (microsoft.public.sqlserver.programming)
  • Re: reclaiming LOB space
    ... Books Online says "Reclaims space from dropped variable-length ... But as I understood Mike, he did not drop the column, only setting the ... Links for SQL Server Books Online: ...
    (microsoft.public.sqlserver.server)