Killing a Process

[nkagi]

Dear All,

I would just like to find out if there's an alternative way of killing a process on SQL Server2000. I always try to logout people who are logged into a database by going to the Enterprise manager then management then current activity, I then right click on the process and click on kill process. But I find that it does not work. Please help me.

[Vaderman]

you can use QA to kill a process. Use sp_who to find out what the users spid number is and then kill this process. BUT, don't kill the process if the cmd reads any of the following:

AWAITING COMMAND, CHECKPOINT SLEEP, LAZY WRITER, LOCK MONITOR, SELECT, or SIGNAL HANDLER.

Hope that helps