Set a Database to Single-user Mode

Single-user mode specifies that only one user at a time can access the database and is generally used for maintenance actions.

The database remains in single-user mode even if the user that set the option logs off. At that point, a different user, but only one, can connect to the database.

To set a database to single-user mode
--> In Object Explorer, connect to an instance of the SQL Server 2005 Database Engine, and then expand that instance.

--> Right-click the database to change, and then click Properties.

--> In the Database Properties dialog box, click the Options page.

--> From the Restrict Access option, select Single.

--> If other users are connected to the database, an Open Connections message will appear. To change the property and close all other connections, click Yes.