At my last company, in SQL SERVER2008R2, I had a stored procedure that sends an email by calling:
BUT at this new company, I don't have permission and am getting the error:
The EXECUTE permission was denied on the object 'xp_sendmail', database 'mssqlsystemresource', schema 'sys'.
What are my alternatives?
Here's what I need: when a new record is inserted into a table, I need to be alerted via an email. AT my last company, the INSERT TRIGGER would run a stored procedure that puts together the email then sends it out by making a call to xp_sendmail
I looked at option 3 but it mentions SQL Agent, which to me means full dba, which I am not.