SQL: Fix for Database stuck in Single User Mode

sql-fix-singleUserMode-database.sql

----- Fix SQL Single User DB/Locked/Etc

USE master;
GO
SET DEADLOCK_PRIORITY HIGH;
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

DECLARE @CMD nvarchar(max);
WHILE 1=1
BEGIN
    SET @CMD = NULL;
    SELECT @CMD = ISNULL(@CMD + CHAR(10), '') + CONCAT(N'KILL ', session_id)
    FROM sys.dm_exec_requests
    WHERE database_id = DB_ID('MySQLDB') AND session_id <> @@SPID;
    IF @CMD IS NULL BREAK;
    PRINT @CMD;
    EXEC(@CMD);
END

ALTER DATABASE MySQLDB SET MULTI_USER WITH ROLLBACK IMMEDIATE;