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