SQL Server Triggers - Enable and Disable
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.
View On WordPress












