Single User Check

[benvegiard]

Hi All,

What's the easiest way to see if a database is currently in SINGLE_USER or MULTI-USER mode?

I tried sp_dboption, and it shows "Single User" as a value, but does not indicate if it's on or off. The DB's I tried it on are known to be in Multi-User mode (or, at least, they are accepting multiple users for read and write)

Thanks,
Ben

 

[JamesLean]

--SQL 2000
SELECT DATABASEPROPERTYEX('mydb', 'UserAccess')

--SQL 7
SELECT DATABASEPROPERTY('mydb', 'IsSingleUser')

--James