Put the Master DB in Single User Mode

Posted on 2004-10-22
Last Modified: 2008-03-17
How do I put the master DB into single user mode using TSQL?
Question by:billy21
    LVL 6

    Author Comment

    Looks like this can't be done.  I just tried this...

    sp_dboption master, Single_User, true

    doesn't work on master.  How can I restore the master database then?
    LVL 10

    Accepted Solution


    From a command prompt, enter:
    sqlservr.exe -c -m

    Note  You must switch to the appropriate directory (for the instance of  SQL Server you want to start) in the command window before starting sqlservr.exe.



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Course: Foundations of Front-End Development

    Jump-start a lucrative career in front-end web development, with zero previous coding experience required. This course covers the basic programming concepts and languages required for creating engaging websites from scratch.

    SQL Server Side Trace is a technique of Profiling SQL Server Events Silently (i.e without Using the Profiling Tool). Running a visual tool in production increases overhead, but we can develop server side Trace using Sql Server Profiler itself. We…
    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Viewers will learn how the fundamental information of how to create a table.

    913 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now