There are two ways to prevent trigger from firing. 1) Drop Trigger Example: DROP TRIGGER TriggerName GO 2) Disable Trigger DML trigger can be disabled two ways. Using ALETER TABLE statement or use DISABLE TRIGGER. I prefer DISABLE TRIGGER statement. Syntax: DISABLE TRIGGER { [ schema . ] trigger_name [ ,...n ] | ALL }… Continue Reading...
Source: SQL SERVER – 2005 – Disable Triggers – Drop Triggers | Journey to SQL Authority with Pinal Dave
No comments:
Post a Comment