Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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

1 Answer 1

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.