***This guide is valid for MSSQL 2000, MSSQL 2005, MSSQL 2008 and MSSQL 2012.
Is your database stuck in single user mode? Irritating isn't it? Use the following command to restore it to normal service, where DBNAME is the name of the database:
exec sp_dboption 'DBNAME', 'single user', 'FALSE'
Is your database stuck in single user mode? Irritating isn't it? Use the following command to restore it to normal service, where DBNAME is the name of the database:
exec sp_dboption 'DBNAME', 'single user', 'FALSE'
go