SQL Server Triggers – Enable and Disable

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.