How to change SQL server database mode from single user to multiuser and multi user to single user

Introduction: In this example you can set database mode to single user or multiuser

Description: Here you will see how to change database mode to single and multiuser.

Implementation:

Set Multi User Mode  to Single User Mode

USE MASTER;
GO
ALTER DATABASE [databasename] SET SINGLE_USER

Set Single User Mode to Multi User Mode 

USE MASTER;
GO
ALTER DATABASE [databasename] SET MULTI_USER