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 |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2003-03-05 : 16:08:56
|
| Hi Folks,I am using xp_sendmail to send notifications to certain users. The stored procedure worked fine yesterday but is failing today. The sql server box has sql server 2000, the SQL Mail is working with the MAIL session started. I get an error saying xp_sendmail fails with error 0x8004010f.Any thoughts on this one.ByeRamdas NarayananSQL Server DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-05 : 16:24:38
|
| You will need to reboot the machine to get it working again. That is what we always had to do when SQL Mail stopped working. We opened several MS cases and finally MS came up with a solution for us. The solution was to install Outlook 2002 on the SQL Server. We were previously using Outlook 2000. Since we have done this, we have not had a single SQL Mail problem.Tara |
 |
|
|
ramdas
Posting Yak Master
181 Posts |
Posted - 2003-03-05 : 16:26:32
|
| Thank you for your prompt reply.Ramdas NarayananSQL Server DBA |
|
|
|
srf
Starting Member
42 Posts |
Posted - 2003-03-06 : 12:30:24
|
| With SQL 7.0 we had to reboot the server, but with SQL 2000 (SP2 and newer) we just have to cycle the SQL Service. We've also removed 99% of the use of SQL Mail until it's rewritten from scratch. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-06 : 12:51:16
|
| Restarting the SQL services has never worked for us on SQL 2000. That is why we opened a case up with MS. Outlook 2002 fixed all of our problems. I would recommend it to anyone who uses xp_sendmail. We now don't have ANY problems with SQL Mail.Tara |
|
|
|
|
|
|
xp_Sendmail