How to get Database out of Single User Mode - SQL Server DBA Tutorial

In this video you will learn how to bring database from Single User mode to Multi User mode using SQL Server Management studio as well as using T-SQL Script. You will learn a scenario where you will put database in single user mode and then bring database in multi User mode so that all the users can access the database.

Change Database out of Single User Mode Script

--How to put Database in single user mode
USE [master]
GO
ALTER DATABASE [Demo] SET  SINGLE_USER WITH  rollback Immediate
GO
--How to put Database in multi user mode
USE [master]
GO
ALTER DATABASE [Demo] SET  MULTI_USER WITH NO_WAIT
GO


How to Get Database out of Single User Mode in SQL Server