Hmmm still don't understand....
I am on a Citrix server, connecting to SQL Server remotely using a local SQLSERVER user.
My NT account has NO permissions to the SQLSERVER box, I can't even login to the server.
When I call the command ....
EXEC msdb..SP_SEND_DBMAIL
@RECIPIENTS= 'XXX@XXX.com',
@PROFILE_NAME = 'MAIL',
@SUBJECT = 'TEST',
@BODY = 'TEST',
@BODY_FORMAT = 'HTML',
@file_attachments = 'C:\New Text Document (2).txt'
The email is successfully sent
I can also send an email using an attachment using a UNC path....
EXEC msdb..SP_SEND_DBMAIL
@RECIPIENTS= 'XXX@XXX.com',
@PROFILE_NAME = 'MAIL',
@SUBJECT = 'TEST',
@BODY = 'TEST',
@BODY_FORMAT = 'HTML',
@file_attachments = '\\comdata01\Shared\orchard.log'
What am I missing?
Peter Gadsby
Business Intelligence Consultant
www.hgconsult.co.uk