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.