Re: Kill Process
From: Aaron Bertrand - MVP (aaron_at_TRASHaspfaq.com)
Date: 05/18/04
- Next message: Alicia: "Re: Growing Database problem,"
- Previous message: Keith Kratochvil: "Re: Triggers and Procedures"
- In reply to: Alicia: "Re: Kill Process"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 18 May 2004 15:29:36 -0400
Maybe it's executing a WSH script, and the server is waiting for someone to
walk by and click "OK" on a MsgBox. :-)
"Alicia" <anonymous@discussions.microsoft.com> wrote in message
news:ABA285E4-A89A-45BE-BBB0-B2A6DCCEC86F@microsoft.com...
> you can add the status_only clause to Kill.
> One question - if it's rolled back 100% but still not ending, is it
running something outside of SQL? I.e. something like sp_OaCreate to run a
COM component or xp_cmdshell or xp_sendmail?
> If that's the case then SQL can lose sight of whether the process is
active or not - normally because the dll (or whatever) hasn't reported
status back.
>
> Alicia
>
> http://www.sqlporn.co.uk
- Next message: Alicia: "Re: Growing Database problem,"
- Previous message: Keith Kratochvil: "Re: Triggers and Procedures"
- In reply to: Alicia: "Re: Kill Process"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
