Tip: Restrict the Connection to a Database in SQL

You can restrict the donnection to a database by specifying Single User mode, as shown below:

USE master;
GO
ALTER DATABASE YourDatabaseName
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO
ALTER DATABASE YourDatabaseName
SET READ_ONLY;
GO
ALTER DATABASE YourDatabaseName
SET MULTI_USER;
GO

This means that only one person can connect to the database until it is set back to Multi User.

Visit the DevX Tip Bank