Friday, February 24, 2012

Database Mail and Application Roles

I am in the middle of converting our application to use SQL 2005. I
need to support "Database Mail" (I guess it was called SQLiMail) as a
replacement for SQLMail.
As soon as I change into the Application Role lose my access to MSDB
and sp_send_dbmail.
How can I maintain the Application Role and still send mail?
Thanks
-Chad
Has anyone using Application Roles in SQL 2005 been able to use the old
xp_ procs like xp_sendmail? I keep getting permission issues and I'm
having a problem building work-arounds.
Thanks
-Chad

No comments:

Post a Comment