The following description is valid for SL Server 2005 and 2008.
I execute following statement :
@profile_name = 'DBMail'
, @recipients = 'firstname.lastname@example.org' -- valid recipient
, @body = 'testmail with attachement from a filershare '
, @subject = 'Testmail'
, @file_attachments = N'\\server\Share\path\file'
Without @file_attachements the Mail was sent. So database mail is active an the profile is configured correctly.
The mail is also sent if the file resides on a local disk.
But sp_send_dbmail throws following message if the file resides on a shared filesystem :
Msg 22051, Level 16, State 1, Line 0
Attachment file \\server\Share\path\file is invalid.
The user executing the proc is sysadmin an has proper rights on the share.
So I assume that this is a bug.
Or do I miss something to configure?