SQL Mail with attachment not working

  • 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)

  • 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

  • Useful link for help troubleshooting MAPI errors: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q238119



    Shamless self promotion - read my blog http://sirsql.net

  • 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