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