SQL Server Kill Process

The kill command is used against a SPID. (Server Process ID). This command is typically used because something is misbehaving. In order to use the Kill command, simply type the word “kill” followed by a space and then the number of the Server Process ID to kill.

[cc lang=”sql”]
— Kill Server process ID 98
kill 98
[/cc]

The kill command has three parameters. Two of which I have no idea what they mean:

KILL { session ID | UOW } [ WITH STATUSONLY ]

2 comments
leo 07 Aug 2014 at 5:55 pm

‘Two of which I have no idea what they mean’ is funny, thanks good article.

Leonardo Raygoza 06 Apr 2011 at 2:17 pm

good article I think this blog is going to be one of my favorites 🙂

Featured Articles

 Site Author

  • Thanks for visiting!