Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««1234

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



Group: General Forum Members
Last Login: Yesterday @ 1:48 PM
Points: 7,765, Visits: 11,376
kapil190588 (10/6/2012)
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:
Post #1369448
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse