SQL code to Enable/Disable a Trigger

Useful code to disable and enable a trigger:



ALTER TABLE YourTable DISABLE TRIGGER ALL
and
ALTER TABLE YourTable ENABLE TRIGGER ALL