Monday, February 24, 2014

SQL commands

Remove database single user mode
exec sp_dboption 'testdb01', 'single user', 'FALSE'

Set database to single user mode
ALTER DATABASE dbName
SET SINGLE_USER WITH ROLLBACK IMMEDIATE