Email Notification Problem

Hi All,
I have a couple of w2k adv. svrs which are also running sql 2000. My DBA has
configured sp_send_mail using outlook 2000 which is also installed on these
servers.
This sp_send_mail is configured to send notifications on daily basis. Out of
25 notifications each day, 2 or 3 fails.
They claim the sp_send_mail stored procedure executes properly so the
problem is with the exchange svr even though there is no trace of these
failed messages in exchange nor even on the client computers where outlooks
mapi32 is initiated.
Is there any way I can figure out in outlook, on the client computers if
these failed messages are even initiated by outlook or not, even though they
claim their stored procedure executes properly always?
Nobody in the company has mail delivery problem with the exchange box or
their outlook clients. I have tested sending emails from outlook on these
servers without any failures yet they claim its exchange 2000.
Any ideas on how to resolve this permanently'The mail support that ships with SQL Server is not fun to work with as it uses MAPI and MAPI was
never designed to be used from services. Have you considered using xp_smtp_sendmail from
www.sqldev.net?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"caddo65590" <caddo65590@.hotmail.com> wrote in message news:O0QAtnEtDHA.980@.TK2MSFTNGP10.phx.gbl...
> Hi All,
> I have a couple of w2k adv. svrs which are also running sql 2000. My DBA has
> configured sp_send_mail using outlook 2000 which is also installed on these
> servers.
> This sp_send_mail is configured to send notifications on daily basis. Out of
> 25 notifications each day, 2 or 3 fails.
> They claim the sp_send_mail stored procedure executes properly so the
> problem is with the exchange svr even though there is no trace of these
> failed messages in exchange nor even on the client computers where outlooks
> mapi32 is initiated.
> Is there any way I can figure out in outlook, on the client computers if
> these failed messages are even initiated by outlook or not, even though they
> claim their stored procedure executes properly always?
> Nobody in the company has mail delivery problem with the exchange box or
> their outlook clients. I have tested sending emails from outlook on these
> servers without any failures yet they claim its exchange 2000.
> Any ideas on how to resolve this permanently'
>