Kill a SPID on SQL Server 2008

Question

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

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

gbn · Answer 1 · 2011-05-18 08:32:01Z

up vote 10 down vote accepted

answered May 18 '11 at 8:32

gbn
4,9271413

1

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

feedback

1 Answer