Checking if SQL Server database is running in MULTI_USER mode

Question

How can I check what mode a particular database is in?

Answer 1

try using the DATABASEPROPERTYEX

SELECT DATABASEPROPERTYEX('databasename','UserAccess')

if the database is in multi_user mode must return MULTI_USER

Answer 2

use sp_dboption like this

EXEC sp_dboption 'DB_NAME', 'single user'

to set it add the option third parameter. See below