Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have a rogue SPID on a MS SQL Server 2008.

Is there a way to kill it without restarting the server?

share|improve this question
up vote 11 down vote accepted


share|improve this answer
This is one of the rare cases where violence is the answer. – splattne May 18 '11 at 9:20
@splattne: I should flag your comment for moderator review because it is glorifying violence, shouldn't I? ;) – abaumg May 18 '11 at 10:00
@abaumg ☮ man... – splattne May 18 '11 at 10:40

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.