cyprich.com

By

MSSQL: How To Get Database Out of Single User

The SQL Server Single User Mode only permits one connection to a database at a time. Great for testing, but not for deployment. Here is how you can get it out of this state.

Open the Microsoft SQL Server Management Studio. Start a new SQL query and enter the code below with the database you want to restore.

ALTER DATABASE YourDatabase SET MULTI_USER

The database will then be ready for multiple users accessing it.

Leave a Reply

Your email address will not be published. Required fields are marked *