Take the 2-minute tour ×
Server Fault is a question and answer site for professional 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
add comment

1 Answer

up vote 11 down vote accepted

KILL

share|improve this answer
2  
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
add comment

Your Answer

 
discard

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.