SQL 2000 xp_sendmail
- by Steven
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