InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 17:56:18 GMT20http://www.sqlservercentral.com/Forums/Topic1384423-391-1.aspxHi,Yes I am sure of the location and the file name and extension.When I try doing the same from our QA server,it works fine, but from our production cluster, I keep getting this errorWed, 14 Nov 2012 00:52:01 GMTCasper101http://www.sqlservercentral.com/Forums/Topic1384423-391-1.aspx[quote][b]Casper101 (11/14/2012)[/b][hr]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.... :([/quote]are you providing the correct extension to file ?Wed, 14 Nov 2012 00:44:06 GMTsanket kokanehttp://www.sqlservercentral.com/Forums/Topic1384423-391-1.aspxWhen 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.... :(Wed, 14 Nov 2012 00:41:36 GMTCasper101