Skip to content
 

SQL Server Kill

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 ]

Related Posts:

Ask a question or post a comment