Friday, October 10, 2014

1 Start SQL Server in Single-User Mode

Add –m in the sql server start up parameter to start SQL Server in Single User Mode.

image

Make sure you stop sql agent otherwise, sql agent will take the only connection right away.

Reference

http://msdn.microsoft.com/en-us/library/ms188236.aspx

Posted by Po@sqlpanda at 4:31 PM
Labels: ,

1 comments:

  1. Thetechie findFebruary 24, 2020 at 2:08 PM

    Find trendy technology stock photos in HD and tens of millions of different royalty-loose stock photographs, illustrations and vectors within the Shutterstock series.


    Random Email Generator
    Black light app
    Temp mail
    Terrarium TV App
    tik tok
    ERP software

    ReplyDelete

Subscribe to: Post Comments (Atom)
 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates