Timeline for Trouble With Database Permissions for sp_send_mail
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 22, 2012 at 17:26 | comment | added | Remus Rusanu |
The cleanest way is to have a local stored proc in your DB, and have the call to msdb.dbo.sp_send_mail in this local SP body. Have the trigger call this local SP. Code sign the SP.
|
|
| Mar 22, 2012 at 17:24 | history | edited | Remus Rusanu | CC BY-SA 3.0 |
added 110 characters in body
|
| Mar 22, 2012 at 17:21 | comment | added | Kyle Brandt | In the long run I am trying to have this executed as a trigger, so my EXECUTE AS is a way of testing in the short term... | |
| Mar 22, 2012 at 17:14 | history | answered | Remus Rusanu | CC BY-SA 3.0 |