SQL Script to Chage the mode to Single and Multi User

To change from multi to single mode


ALTER DATABASE [Work]   --DB Name
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE


To change from single to multi mode


ALTER DATABASE [Work]   --DB Name
SET MULTI_USER
GO