Disable Trigger

To disable the trigger use this syntex:

DISABLE TRIGGER triggerName ON TableName;

To disable all triggers of available server:

DISABLE Trigger ALL ON ALL SERVER

Solutions By:Rajesh Rolen