Wednesday, September 26, 2012

SQL Error 924 Database Single User mode change to Multi Users mode

exec sp_lock --- find the spid by dbid with lockType X Kill spid ----- kill the Spid exec sp_who --- find the Spid Kill spid ----- kill the Spid again ALTER DATABASE EmailXtender Set MULTI_USER

1 comment:

  1. You can check the reason behind the SQL error 924 by using SQL Profiler. By using T-SQL in SSMS, fix database error.

    T-SQL Commands are:
    USE master;
    GO
    ALTER DATABASE youdbname
    SET MULTI_USER
    WITH ROLLBACK IMMEDIATE;
    GO

    In case this solution doesn’t work then you can try professional tool as well. I have found "Stellar Repair for MS SQL professional tool" in Microsoft forum (Social Technet). Through this you can fix SQL error 924.

    Read below blog post to know more methods:
    https://www.techpcvipers.com/sql-database-repair-software/

    ReplyDelete