#enable trigger in sql server

A disabled trigger is still present in the current database as an object, but it does not fire. Enabling a trigger does not result in its re-creation.

In this article, you’ll know how to enable and disable triggers in SQL Server. Syntax and Example: DISABLE TRIGGER trgEmpInsDelUpd ON Emp; GO ENABLE TRIGGER trgEmpInsDelUpd ON Emp; GO A disabled trigger is still present in the current database as an object, but it does not fire. Enabling a trigger does not result in its re-creation. Hope you find this article helpful.