Post reply

How to create proxy account for sp_send_dbmail in sql server 2008

  • April 21, 2011 at 3:33 am

    #389343

    How to create proxy account for sp_send_dbmail in sql server 2008. Calling user is non sys admin and we have to attach UNC File

  • April 21, 2011 at 6:26 am

    #1314452

    Give below permission to the user in msdb

    USE [msdb]

    GO

    EXEC sp_addrolemember N'DatabaseMailUserRole', N'user'

    GO

    You can send mail.

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply