I am trying to use a Trigger to execute the xp_sendmail stored procedure so a notification message will be sent after a new record is inserted. Here is the code I used to create the trigger:
CREATE TRIGGER [trgEmailGreg] ON [dbo].[tblRMR]
@recipients = 'Brick, Greg',
@message = 'A new RMR has been submitted. Please review and disposition as necessary',
@subject = 'New RMR submitted'
Every time I try to insert a record I get an error saying the xp_sendmail stored procedure cannot be found.
Why is this happening?
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.