• Casper101 (11/14/2012)


    When I try to send and Attachment (@file_attachments ) with sp_send_dbmail, I receive this error:

    "Attachment file ***** is invalid"

    The file does exist and the SQL login is sysadmin.

    The file location is not locally on the SQL server but on a different server (shared folder).

    I have given the SQL Service Account (Service and Agent) Full permissions to this share folder, but I still get the error.

    What am I doing wrong? What am I missing?

    I even tried mapping the shared folder to a drive letter and using this drive letter in the @file_attachments parameter - but stil the error.

    Please help.... 🙁

    are you providing the correct extension to file ?

    -----------------------------------------------------------------------------
    संकेत कोकणे