Issues with sql mail in SQL 2000

I am using Outlook 2003 and sql 2000 and POP email service.

When completing backup jobs, I want an email notification to be sent out.
The email is not being received. Only when I stop sql server and open outlook
on the server do all the emails get sent out.

If I keep outlook open on the server and then try to send out email through
sql, I receive a sql error.

If I start sql first and then open outlook, outlook says the PST is locked.

With my above setup (outlook 2003 SP1, sql 2000, POP), How can I get email
notifications after backup job is complete. Any help is appreciated.

Hello Jack:

If you can, upgrade your SQL to 2005. The advantages are significant, but
the one you will be most interrested in is that SQL 2005 does NOT rely on
Outlook for mail. It uses SMTP.

Failing that, if you still need to stay on SQL 2000, but are willing to use
a solution that by-passes Outlook and goes through SMTP, do a google search
on xp_smtp_sendmail. IT is a free utility / extended stored procedure that
you can download and install fairly easily. We used it for a couple of years
until 2005 came out.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


"Jack" wrote:

> I am using Outlook 2003 and sql 2000 and POP email service.
>
> When completing backup jobs, I want an email notification to be sent out.
> The email is not being received. Only when I stop sql server and open outlook
> on the server do all the emails get sent out.
>
> If I keep outlook open on the server and then try to send out email through
> sql, I receive a sql error.
>
> If I start sql first and then open outlook, outlook says the PST is locked.
>
> With my above setup (outlook 2003 SP1, sql 2000, POP), How can I get email
> notifications after backup job is complete. Any help is appreciated.