[SQL Server] Set a database to a single-user mode

[SQL Server] Set a database to a single-user mode

Set a database to a single user - in order to have maintenance or something.

Test Steps
How to change a database to a single-user mode with T-SQL

ALTER DATABASE SingleDBTest
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE;
GO

Check from Object Explorer

Test with T-SQL

USE SingleDBTest
GO

Msg 924, Level 14, State 1, Line 1
Database 'SingleDBTest' is already open and can only have one user at a time.

Change a database to a multi-user mode

ALTER DATABASE SingleDBTest
SET MULTI_USER
GO

References

• Set a Database to Single-user Mode: https://docs.microsoft.com/en-us/sql/relational-databases/databases/set-a-database-to-single-user-mode?view=sql-server-ver15