Advertisement
mike_fal

Script out Kill All Spids

Jan 7th, 2014
154
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.13 KB | None | 0 0
  1. SELECT
  2.     'KILL '+CONVERT(varchar(10),session_id)+';'
  3. FROM
  4.     sys.dm_exec_sessions
  5. WHERE
  6.      session_id != @@SPID
  7.      and session_id >50;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement