General discussion

Locked

SQL Question

By bfeltus ·
How do I access sql in single-user mode?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Question

by Joseph Moore In reply to SQL Question

You have to turn on Single User mode on the database itself; you can't issue a connection command that forces the database into single user.
Open Enterprise Manager, drill down to your SQL server, expand the Databases until the one you want is visible, right-click -> Properties -> Options tab.
Under the Access section, select the Restrict Access checkbox, then below that select Single User Mode.
Click OK.


That's it.

Make sure no one is connected to the DB before you do this, though!

Now connect to the SQL server before anyone else does.

hope this helps

Collapse -

SQL Question

by bfeltus In reply to SQL Question

Poster rated this answer

Collapse -

SQL Question

by mwchub In reply to SQL Question

In order to start an instance of Microsoft? SQL Server? in single-user mode using the startup option -m. This will bring up the entire server in single user mode, no one else will be able to access it while you are connected to it. You may also wantto change the port number to something only you know for the time being.

Collapse -

SQL Question

by bfeltus In reply to SQL Question

Poster rated this answer

Collapse -

SQL Question

by bfeltus In reply to SQL Question

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums