Friday, 24 July 2015

MSSQL - Kill all my processes (except current)

Template to kill all my processes (connections) except current

  1. USE master
  2. GO
  3.  
  4. DECLARE @sql VARCHAR(MAX) = '-- Kill all my processes (except current: '
  5. + CAST(@@SPID AS VARCHAR(20)) + ')';
  6. SELECT @sql = @sql + CHAR(13) + CHAR(10) + 'kill ' + CONVERT(varchar(5), spid) + ';'
  7. FROM master..sysprocesses
  8. WHERE hostname = HOST_NAME() AND spid != @@SPID;
  9.  
  10. PRINT @sql;
  11. EXEC (@sql);

After execution we have something like this:

-- Kill all my processes (except current: 80)
kill 52;
kill 53;
kill 73;

No comments:

Post a Comment

Note: only a member of this blog may post a comment.