Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 xp_startmail: failed with mail error 0x80040108

Author  Topic 

dempen
Starting Member

7 Posts

Posted - 2010-11-30 : 02:50:30
Hi there,

I have a job running on a 2000 which reads incoming email from Exchange, performs various actions depending on the emails' content and then send an email using xp_sendmail.

In the beginning of my script I stop and start SQLMail using the following code:
EXEC master..xp_stopmail
EXEC master..xp_startmail

Every once in a while the script fails with the error code: "xp_startmail: failed with mail error 0x80040108"

When that happens we have nothing to do but to restart the server! Has anyone else experienced this error and know why it happens and/or how we can solve it without having to restart the whole server??

dempen
Starting Member

7 Posts

Posted - 2010-12-20 : 04:07:15
quote:
Originally posted by dempen

Hi there,

I have a job running on a 2000 which reads incoming email from Exchange, performs various actions depending on the emails' content and then send an email using xp_sendmail.

In the beginning of my script I stop and start SQLMail using the following code:
EXEC master..xp_stopmail
EXEC master..xp_startmail

Every once in a while the script fails with the error code: "xp_startmail: failed with mail error 0x80040108"

When that happens we have nothing to do but to restart the server! Has anyone else experienced this error and know why it happens and/or how we can solve it without having to restart the whole server??

Unsolvable problem...?
Go to Top of Page
   

- Advertisement -