Skip to content
 

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.

-- Kill Server process ID 98
kill 98

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

KILL { session ID | UOW } [ WITH STATUSONLY ]



Popular search terms:

One Comment

  1. Leonardo Raygoza says:

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

post a comment OR Post Your Question on our ASK! Community!