I have created triggers to log inserts, updates, and deletes on a good number of tables. The purpose is to log who changes what, and to be able to track changes to certain important fields, regardless of who changes them. However, I don't need to log certain program-created updates. For example certain fields are automatically updated each day for hundreds or even thousands of records. Therefore, the logging triggers created hundreds or even thousands of log entries each day that are just clutter. Is there a way my stored procedure can disable a trigger, do its job, and then re-enable?

I've tried:

ALTER TRIGGER MyTrigger ENABLE;
do some work...
ALTER TRIGGER MyTrigger ENABLE;

Of course, these commands are not legal.