How to Restart SQL Server in Single-User Mode ?

26 Reads Ms Sql

There are a couple of ways to start SQL Server in single-user mode..

  • You can start an instance of SQL Server in single-user mode by using the startup option –m
  • You can use -m option with sqlcmd or Management Studio
  • You can also start sqlservr.exe with –m option
Ms Sql

You May Interest

What is SQL Profiler ?

What is the Difference Between CHAR and VARCHAR Datatypes in SQL ...

What is the Difference Between VARCHAR and VARCHAR(MAX) Datatypes ...

How to Learn MS SQL Server Version

List of Table Columns Used in Any View in MS SQL