• 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