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
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.
You can check the reason behind the SQL error 924 by using SQL Profiler. By using T-SQL in SSMS, fix database error.
ReplyDeleteT-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/