How to kill spid 101,101,102,.......300

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  October 22, 2007 at 1:39 pm

  #120810

  One of our developers created a whole lot of consecutive unwanted spids. I tried this:

  declare @i as int

  set @i = 101

  while (@i <= 300)

  begin

  set @i = @i + 1

  kill @i

  end

  and found that "kill" does not like the use of @i. How would you do this?

  TIA,

  barkingdog

• Adam Angelini

  SSCrazy Eights

  Points: 8548

  More actions

  October 22, 2007 at 2:04 pm

  #744238

  declare @i as int

  declare @sql varchar(20)

  set @i = 101

  while (@i <= 300)

  begin

  set @sql = 'kill ' + cast(@i as varchar(4))

  execute (@sql)

  set @i = @i + 1

  end