SQL Server: Test if DB is Single User

Question

Hello.

How test if the DB is in single user mode in a sql script?

Thanks.

Eduardo

Answer 1

You can check the sys.databases view:

if (select user_access_desc from sys.databases where name = 'YourDb') = 'SINGLE_USER'
    begin
    print 'It''s in single user!'
    end