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

1 comment:

  1. TODAY I GOT MY DESIRED XMAS LOAN AMOUNT $520,000.00 FROM A RELIABLE AND TRUSTED LOAN COMPANY. IF YOU NEED A LOAN NOW EMAIL CONTACT drbenjaminfinance@gmail.com

    Hello, I'm here to testify of how i got my loan from BENJAMIN LOAN FINANCE(drbenjaminfinance@gmail.com) I don't know if you are in need of an urgent loan to pay bills, start business or build a house, they offer all kinds of loan. So feel free to contact Dr. Benjamin Owen he holds all of the information about how to obtain money quickly and painlessly without cost/stress via Email: drbenjaminfinance@gmail.com

    Consider all your financial problems tackled and solved ASAP. Share this to help a soul right now THANKS.

    ReplyDelete