April 22, 2004 at 8:03 am
Hi,
I am able to send normal mails from SQL Server with no attachments.
But when i am trying to send mail with an attachment i get following error.
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80004005
I am running SQL Server 2000 , SP3.
select @@version
---------------------------------
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
April 22, 2004 at 9:39 am
How about try to stop sql-mail and then re-start it.
xp_stopmail
xp_startmail
Test your xp_sendmail with attachment again. Good luck.
mom
April 22, 2004 at 10:38 am
Useful link for help troubleshooting MAPI errors: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q238119
April 23, 2004 at 1:55 pm
personally, I've founds SQLMail flaky, and troubleshooting disrupts my sleep hours, just like the limitations in the FTP commands in DTS.
I tend to use other free smtp commandline programs to fire off an email with attachments.
"Nothing wrong with picking up a different hammer if the your first one is stuck in the wood."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply