>>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
Thank you a million-fold. I knew it could be done just couldn't figure out where. Truly do appreciate the reply.

Thanks again,
George