T-SQL syntax to avoid firing a trigger?
Posted on 2008-10-22
I have a field that when it is updated causes a trigger which fires off an email to warn a department of a modification that was made to a field.
However, the department concerned who have the final word also make a change to this field and therefore do not need an email when they perform the change.
Is there any stored procedure syntax which would prevent the 'update trigger'. This would be my preferred solution.
However if this cannot be done, how can I test the user account that is being used to update the field so that I can check for this when the trigger fires?