Hello,
We have setup our SQL 2005 server to email error messages using a stored procedure. The stored procedure in turn calls the sp_send_dbmail command to send the email. Our database access is setup using application role security. The problem is, when our application calls a stored procedure which in turn calls our send mail procedure, we get an error saying 'execute permission was denied on the object sp_send_dbmail'. This appears to be because of the application role security - the app call to the server is running in the context of the application role. Has anyone had any success with using DBMail with application roles?
Thanks in advance!