• kapil190588 (10/6/2012)


    hi,

    Can anyone tell me How to check whether the database is in single user mode or multi user mode?

    SELECT user_access, user_access_desc

    FROM sys.databases

    WHERE name = 'YourDatabase';


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/