Pages

Wednesday, August 21, 2013

SQL SERVER – 2005 – Disable Triggers – Drop Triggers | Journey to SQL Authority with Pinal Dave

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