Disable Trigger | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Disable Trigger

Hi EveryBody! Is there a way to disable a trigger on a Table and enable it back? Thanks,
You can use ALTER TRIGGER command lets you to permit you to temporarily disable an update trigger without dropping it and you can disable one trigger or use the ALL keyword to disable all triggers for a table. Refer to books online for more information. Satya SKJ