-- Find requests being blocked SELECT * FROM sys.dm_exec_requests WHERE blocking_session_id <> 0; GO -- Generate SQL to kill everything blocking session id 85 SELECT distinct 'kill ' + CONVERT(varchar,blocking_session_id ) FROM sys.dm_os_waiting_tasks WHERE session_id = 85;