Kill SQL SPIDs for a certain SPID range, or a Date Range

• AndrewSQLDBA

  SSC-Insane

  Points: 21827

  More actions

  September 4, 2013 at 9:40 am

  #281966

  Hello Everyone

  Is there a way to kill SPIDs in a certain SPID range? like all spids 75-100 etc... Or with a date range? Say all SPIDs that are over a day old? I am seeing some stale connections that are not closing.

  Thanks

  Andrew SQLDBA

• MyDoggieJessie

  SSC-Forever

  Points: 44519

  More actions

  September 4, 2013 at 10:07 am

  #1647392

  I would create a simple function or just throw the results into a parameter table and loop through the spids, executing a kill command for each (you could also use a cursor). you could play with the query below to ensure you only get the spids you truly want to KILL...

  SELECT spid FROM sys. sysprocesses P

  JOIN sys .sysdatabases D ON (D .dbid = P. dbid)

  WHERE LTRIM (RTRIM( D.Name )) = @dbname

  AND P. spid != @@SPID

  ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience