Repairing with DBCC CHECKDB

• Hugo Kornelis

  SSC Guru

  Points: 64790

  More actions

  October 6, 2012 at 10:46 am

  #1546434

  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/