Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««1234

Repairing with DBCC CHECKDB Expand / Collapse
Author
Message
Posted Saturday, October 6, 2012 10:46 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:40 AM
Points: 5,916, Visits: 8,166
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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1369448
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse