However, the trigger does not fire when any [!INCLUDE tsql] statements on which it was programmed are executed. Triggers can be re-enabled by using ENABLE TRIGGER. DML triggers defined on tables can ...