Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
capturing errors thrown by xp_sendmail
I found a possible way to get the message -- you can use DBCC OUTPUTBUFFER (passing the spid) to get the output xp_sendmail sends to the console and parse through that to get the error number/message. If anyone can think of an easier way, let me know.- spencer2
- Post #2
- Forum: Microsoft SQL Server: Programming
-
capturing errors thrown by xp_sendmail
I have a procedure that calls xp_sendmail. I would like to capture errors that occur when xp_sendmail loses its connection to exchange, but even though the message is outputted to the screen in query analyzer and captured by the sql agent job history when running the procedure as a job, I...- spencer2
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
xp_sendmail: failed with mail error 0x80004005
Did you ever figure this one out? I am experiencing the same error, but for possibly a different reason -- I have a sql agent job in SQL Server 2000 SP2 that runs every 10 minutes to send out any e-mail alerts I have stored in a database staging table. The job was running fine until a few days...- spencer2
- Post #2
- Forum: Microsoft SQL Server: Programming
