akramarev
3/16/2018 - 9:25 PM

mssql kill all sessions

DECLARE @kill varchar(8000) = '';  
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  
FROM sys.dm_exec_sessions
WHERE 
	database_id  = db_id('DBUser')
	AND login_name IN ('DBTest', 'DBServices')

EXEC(@kill);