Hi Guys,

I have a trigger that sends an email once a value has been changed.

It works when i make any amendments but when the users make the changes it fails.

I have figured out the users havnt got permission to send mails in master.dbo.xp_sendmail

The way the DB was originally setup wis shocking!! (each user has a network login rather than being part of a network group)

Is there anyway i can allow a role in customerDb to access the xp_sendmail proc in the mater db?

Thanks Sp