Home Forums SQL Server 2005 T-SQL (SS2K5) sp_send_dbmail fails within a trigger RE: sp_send_dbmail fails within a trigger

  • December 21, 2010 at 5:07 am

    #1264997

    I set the permissions for user 'User1' using:

    USE msdb

    EXEC msdb.dbo.sp_addrolemember @rolename = 'DatabaseMailUserRole',@membername = '[User1]';