Remove Single User Mode #sql

RemoveSingleUserMode.sql

USE master
GO
DECLARE @kill varchar(max) = '';
SELECT @kill = @kill + 'KILL ' + CONVERT(varchar(10), spid) + '; '
FROM master..sysprocesses 
WHERE spid > 50 AND dbid = DB_ID('DATABASENAME')
EXEC(@kill);

GO
SET DEADLOCK_PRIORITY HIGH
ALTER DATABASE {DATABASENAME} SET MULTI_USER WITH NO_WAIT
ALTER DATABASE {DATABASENAME} SET MULTI_USER WITH ROLLBACK IMMEDIATE
GO