Kill process

If I have a process running and I want to kill it, and I right click on the
process, and select "kill process", why does it not get killed? How do I
kill it?
Message posted via http://www.sqlmonster.com
in Query Analyzer:
KILL XX
Where XX is the Spid
Greg Jackson
PDX, Oregon
|||On Tue, 08 Feb 2005 19:38:46 GMT, Robert Richards via SQLMonster.com
wrote:

>If I have a process running and I want to kill it, and I right click on the
>process, and select "kill process", why does it not get killed? How do I
>kill it?
Hi Robert,
If you do this frome Enterprise Manager, then don't forget to refresh the
view.
Also, if the process has been changing data, all changes have to be rolled
back. This can take some time (rolling back is often slower than making
the changes)
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||You can use the following to see the status; the process may be in rollback:
KILL (spid number) WITH STATUSONLY
"Robert Richards via SQLMonster.com" wrote:

> If I have a process running and I want to kill it, and I right click on the
> process, and select "kill process", why does it not get killed? How do I
> kill it?
> --
> Message posted via http://www.sqlmonster.com
>