If we have a trigger and want to prevent it from running, we can either delete the trigger or disable it temporarily. With the trigger disabled, it will not function. We have three ways to enable/disable a trigger in SQL Server by using a graphical option or by using a query editor.
We will see two ways of disabling a trigger using a query editor.
In the example below, we will assume that we have a TRG_EmployeeHistory trigger already created on the Employee table.
Disabling/enabling a trigger with the ALTER TABLE option
Disable a Trigger
ALTER TABLE EMPLOYEE
DISABLE TRIGGER TRG_EmployeeHistoryEnable a Trigger
ALTER TABLE EMPLOYEE
ENABLE TRIGGER TRG_EmployeeHistorySpecifying the trigger and the table name to enable/disable triggers directly
Disable a Trigger
DISABLE TRIGGER TRG_EmployeeHistory ON EMPLOYEEEnable a Trigger
ENABLE TRIGGER TRG_EmployeeHistory ON EMPLOYEEUsing the Graphical Option to enable/disable a trigger
Follow the instructions below.
[+] Object Explorer
[-] Database Name
[-] Table Name
[-] expand Triggers
[-] Right-click on the trigger name to enable/disable it.
