Checking the health of the SQL Server database in MULTI_USER mode

Question

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

Answer 1

try using DATABASEPROPERTYEX

SELECT DATABASEPROPERTYEX('databasename','UserAccess')

if the database is in multi_user mode, should return MULTI_USER

Answer 2

use sp_dboption like this

EXEC sp_dboption 'DB_NAME', 'single user'

to set it, add the third parameter parameter. See below