I am running sql server 2005 on windows server 2003. I have some stored procedures that send e-mail notifications when they are run. It will run fine, sometimes for days or even weeks, then it will suddenly fail. The stored procedure uses the:
method. When it fails, it fails on the xp_startmail line and returns this error:
Msg 17925, Level 16, State 1, Line 0
xp_startmail: failed with mail error 0x80040108
I have to restart the sql server service and then it works fine again. Just restarting the agent alone doesn't work. Has anyone experienced this before?