Today I will discussed about, how to restrict access to single user.
Why need restrict access database?
* Single-user mode specifies that only one user at a time can access the database and is generally used for maintenance actions.
* When multiple users are connected to the database at the time that you set the database to single-user mode, their connections to the database will be closed without warning.
How to setup database to single user mode.
Step 1: Go to Start menu > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio and Connect to database server
Step 2: Right-click the database and click Properties.
Step 3: In Database Properties dialog box, click Options page from left menu.
Step 4: Select SINGLE_USER from the Restrict Access option
Step 5: 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.