Discussion Locked

SQL Server 7.0 - xp_sendmail error

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We have 4 7.0 SQL Server's that have been upgraded to service pack 2. One of the servers will stop sending e-mails after 1 to 4 days. It does not log an error message and the job that is sending the message continues to run. Some (but not all) messages continue to be sent from the server. All four of these servers are using the same e-mail account and are logged into the network with the same login ID.

I can trace the occurrence of the error to a specific date, March 5, 2001. No updateswere made to this server within a month of this date. This server has also had disk space issues. It does not have this issue now.

5 replies

by ronshonk

Check the Event Viewer Application Log Settings. Your Application Log maybe full, thus no longer recording errors. Either increse the maximum log size or choose Overwrite as needed.

by estebandelatorre

Check for the email account properties.
Does it still exists
It's not full
No proxy or firewall between the exchange server and the sql.

Hope it help

by shanghai sam

I found out that the mail box did have a lot of messages in it (4000 +), but we could not see the messages from Outlook or Exchange. See microsoft article Q261133. We also needed to install SQL Server 7.0 Service Pack 3 and then use the mdbvu32 application to remove the messages from the root directory.

This discussion is closed to new replies.