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 ]

Share and Enjoy:
  • Print this article!
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks

Related Posts:

  • » Using sp_who2
  • » What Version of SQL Server Am I Running?
  • » Determine Database Owner
  • » A Better sp_who2 using DMVs (sp_who3)
    blog comments powered by Disqus