Hi,

I have a problem with processing of xp_sendmail procedure. Firstly a general overview on my configuration;

an outlook which use PostOffice as SMTP and POP3 server,
SQL mail service which has a profile that uses outlook profile,
and a insert trigger which uses xp_sendmail

my questions;

when outlook does not response (which means can not send mail) xp_sendmail also does not response and locks my table and the process still executes.
1) Even I want to kill the process, it does not let me do. So, I restart the SQL Server. How can I kill this process?
2) Is there a way that senses that outlook crash and stops or not let to start xp_sendmail process in a trigger.

Thanks for an advice.