Sending attachment using Database Mail

  • Currently, I am getting this error message when I try attaching a file at the location stated in the message using SQL Server 2008:

    Msg 22051, Level 16, State 1, Line 0

    Attachment file F:\VerificationProcess\Door_Access\Supervisor\BRIDGET NELSON.pdf is invalid.

    I can put the file at the root of F:\ and E:\ and it works but if I create the same structures on drive E: I get the same message except point to E:.

    I am trying to figure object or user needs to be add to the folders to access that location the grab the attachments.

    Thanks

  • Seems to be SPACE in the file name.

    try with out space in the file path or enclose it in double quotes.

  • Make sure you have set the correct permissions on the folder to the SQL Service account.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply