>Ok, this is a *little* off the subject but hopefully an SQL expert out there can give me a quick answer to this.
>
>I have created a trigger on MS SQL server that will send an email if a row in a certain table is updated. This works fine as long as I am logged in as 'sa' but everyone else seems to get an error that they do not have permission to use this extended stored procedure.
>
>I know that you can grant rights to stored procedure but I can't seem to figure out how to give people this right. Any ideas?
>
>TIA,
>George
You should be able to assign Execute rights to the user in the Enterprise Manager. Open the Databases folder for the server in question. Then open Master/Objects/Extended Stored Procedures. Right-click the xp_sendmail procedure and click Permissions. Grant Execute rights to the necessary users.
HTH
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams