YSLGuru (11/20/2009)
Jack Corbett (11/20/2009)
There is a role, DatabaseMailUser, in msdb that you can put users in.I'm a fan of option 1 in your case, even though Database Mail is asynchronous, I just don't like sending mail from a trigger, you could do it.
I'm doing some research on issues like this using signed modules. I'll have to see if it will work here.
Thanks for the tip on the role Jack. I thought I had tried using this already and ity didn't work but I also may just have it mixed up with something else. Eve have one of those times where you've tried so many various methods you can't remember specifics on each?
I know that Option #1 is a working option and seems to have a lot of backing among users from internet posts I've seen on this but it just also seems like more of a hack then a solution. Its not a bad hack but still a hack. Any idea if this issue is fixed in 2008?
Yup, been there when you can't remember if you tried everything or not.
Option 1 is the option of choice because SQL Mail was/is synchronous and should never have been in a trigger, but Database Mail is asynchronous so it can be used in a trigger, but I still prefer not to it (old habits and prejudices die hard). This has not been changed in 2008, you still need rights on Database Mail to send mail.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question