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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-02-19 : 07:51:39
|
| Phillip writes "Hi to all!!> HELP NEEDED on xp_sendmail. NOTHING in Knowledge Base!!!>> We have a stored procedure that retrieves e-mail adresses> of users with outstanding work from a table and send them> an e-mail. This SP has been running fine for more than a> year but suddenly it starts failing with this message:>> Server: Msg 18024, Level 16, State 1, Line 0> xp_sendmail: failed with operating system error 80.>> The SP has not changed. The data in the tables and views> and adresses have been checked and is FINE. Users and> permissions are still the same and same as other procs> using xp_sendmail.>> PLEASE NOTE that On the same SQL server we have other> SProcs also using xp_sendmail and they work just fine!>> So what gives? What is OS Error 80? Couldn't find> anything on this in BOL, PASS groups, Technet, KB, Logal> SQLUG etc.>> This is essential to our business. Any help will be> appreciated!!" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-19 : 12:39:55
|
| We continually had SQL Mail problems until a little while ago. It kept failing with different errors. The only way that we could get it to work would be to reboot the machine. We had a few MS calls in and nothing was ever fixed until they suggested installing Outlook 2002. That has solved all of our SQL Mail problems! I don't know, nor do I really care since it isn't failing anymore. SQL Mail has been working for the past couple of months without a single failure. Before, we had failures about once a week. Good Luck! |
 |
|
|
|
|
|
New problems with xp_sendmail