480
If you work with SQL Server databases, you know it’s important to control who can access them. To do that, you can set your database to either SINGLE USER mode (one person can access it at a time) or MULTI USER mode (multiple people can access it at once). In this blog post, I’ll show you how to switch your database between these two modes using T-SQL scripts. This guide will help us better understand database access modes and improve our SQL Server database management skills, whether we’re new or experienced.
T-Sql
--Creat a test database
CREATE DATABASE [MyTestDb]
GO
--Set database to single user
ALTER DATABASE [MyTestDb] SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
GO
--Set database to multi user
ALTER DATABASE [MyTestDb] SET MULTI_USER
WITH ROLLBACK IMMEDIATE
GO
Note
For further information on this post, kindly refer to the original source provided in the link below.
Source: microsoft
