Home Forums SQL Server 2005 Data Corruption How to put database in single user mode while dbcc CheckDB? RE: How to put database in single user mode while dbcc CheckDB?

  • October 2, 2007 at 7:32 am

    #738144

    In MSSQL 2000 -

    EXEC sp_dboption 'DatabaseName', 'single user', 'true'

    GO

    In MSSQL 2005 -

    ALTER DATABASE [DatabaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    GO

    ALTER DATABASE [DatabaseName] SET SINGLE_USER

    GO

    Tommy

    Follow @sqlscribe