How to set single and multiple use mode in SQL

If the database is in single user mode then You can bring that database to normal state following way.

ALTER DATABASE Database_Name SET MULTI_USER

Go to ssms ->right click on database properties--> select options then scroll down to "Restrict Access" then change it MULTI_USER

Comments