3

I'm using Service Broker to [maybe] monitor my database events, so I have my activation sp in some user database and it should react on some events by sending e-mail to admin. But it fails with the error

The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo

while trying to use sp_send_dbmail.

How can I manage the permissions in my case?

sepupic
  • 11,267
  • 18
  • 27

0 Answers0