USE [master]; DECLARE @kill varchar(8000) = ''; SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';' --select * FROM sys.dm_exec_sessions WHERE database_id = db_id('AXDB') EXEC(@kill); ALTER DATABASE AXDB SET MULTI_USER WITH ROLLBACK IMMEDIATE;