Disable trigger in SQL Server

Updated on August 30, 2015 Kisan Patel

This tutorial will show you how to disable a trigger in SQL Server?

To disable a trigger, open the query window and DISABLE TRIGGER statement and execute it.

DISABLE TRIGGER UPDATETrigger1 ON Region

This will disable the trigger named “UPDATETrigger1” that is on Region table.

After disabling the trigger, refresh the Triggers folder and see the icon change between this trigger and other triggers.

Now, when a new record is inserted into Region table, this trigger won’t fire.

SQL Server

« Previous