SQL Trigger: Enabling/disabling 
Saturday, August 9, 2008 at 11:00PM
David Abrahams

You may come across a time when you want to INSERT additional records into a table. But the INSERT statement may have been using a TRIGGER, which may affect other tables. In this scenario, you can use enable/disable properties of the trigger rather than deleting and re-creating it again. Just use the following:

ALTER TABLE yourtablename DISABLE TRIGGER ALL

--Here write your additional script

ALTER TABLE yourtablename ENABLE TRIGGER ALL

Article originally appeared on kmsystems - Web Application Development (http://kmsystems.squarespace.com/).
See website for complete article licensing information.