We are having problems with SQL Mail. We depend heavily on xp_sendmail to send out reports, and our exchnage server has been going down frequently.
When SQL Generates an e-mail when the exchange server is down, we get the following error message:
xp_sendmail: failed with mail error 0x80040115 [SQLSTATE 42000] (Error 18025). The step failed.
Why wouldn't this message be stored in the Outlook outbox and get sent when the connection to the exchange server was back up ?
Also, would configuring SQL mail to use an smtp profile be of any help with the queing issue. Would this methodology provide the ability of the message to be queued and sent when the mail server became available.
Which Methodology would be the best fro our situation.
Any help on this would be greatly appreciated, we are going nuts re-generating mail messages !!