Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Put the Master DB in Single User Mode

Posted on 2004-10-22
Medium Priority
Last Modified: 2008-03-17
How do I put the master DB into single user mode using TSQL?
Question by:billy21
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Author Comment

ID: 12381127
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

lengreen earned 2000 total points
ID: 12381289

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.



Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

597 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