Ghazi Sarhan's Blog - Disable/Re-enable Trigger

Sunday, December 16, 2007

Sometimes you need to temporary disable a trigger, without dropping it, the following commands do this...

To disable a trigger:

Disable Trigger Table_1_Trigger On Table_1

Alter Table Table_1 Disable Trigger Table_1_Trigger

To Re-enable it:

Enable Trigger Table_1_Trigger On Table_1

Alter Table Table_1 Enable Trigger Table_1_Trigger

Sunday, December 16, 2007 6:43:18 PM UTC

Comments [0] -
SQL Server

Name
E-mail
Home page

	Remember Me
Comment (Some html is allowed: `a@href@title, strike`) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.
Enter the code shown (prevents robots):
Live Comment Preview