Kill a SPID on SQL Server 2008

Asked May 18 '11 at 08:10

Active May 18 '11 at 08:38

Viewed 430 times

4

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

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

edited May 18 '11 at 08:38

splattne

28,508
20
98
148

asked May 18 '11 at 08:10

Shiraz Bhaiji

2,229
9
34
47

1 Answers1

11

answered May 18 '11 at 08:32

gbn

6,079
1
18
21

2

This is one of the rare cases where violence *is* the answer. – splattne May 18 '11 at 09: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