Home Forums SQL Server 2005 Administering Getting SQL Server 2005 Database out of Single-User Mode RE: Getting SQL Server 2005 Database out of Single-User Mode

  • December 21, 2006 at 7:48 am

    #679422

    1. Use SP_Who to find the session ID of the active connection to the database
    2. Use KILL <session id> to terminate the connection.
    3. Then do the Alter Database command you tried.

    Hope this helps



    Mark