BOL says this about the KILL command:
 Use KILL very carefully, especially when critical processes are
 running. You cannot kill your own process. Other processes not to kill
 are:
 AWAITING COMMAND
 CHECKPOINT SLEEP
 LAZY WRITER
 LOCK MONITOR
 SELECT
 SIGNAL HANDLER
 Those all make sense except for the SELECT but BOL doesn't elaborate on
 why you shouldn't kill a SELECT statement. Any ideas why they caution
 against this?
 ThanksIt must be a mistake. They removed it from 2005 BOL.
<pshroads@.gmail.com> wrote in message
news:1154975355.227889.163170@.m79g2000cwm.googlegroups.com...
> BOL says this about the KILL command:
> Use KILL very carefully, especially when critical processes are
> running. You cannot kill your own process. Other processes not to kill
> are:
> AWAITING COMMAND
> CHECKPOINT SLEEP
> LAZY WRITER
> LOCK MONITOR
> SELECT
> SIGNAL HANDLER
> Those all make sense except for the SELECT but BOL doesn't elaborate on
> why you shouldn't kill a SELECT statement. Any ideas why they caution
> against this?
> Thanks
>
Tuesday, March 20, 2012
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment