SQL Server > Triggers

Disable a trigger in SQL Server

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 InsertAccounts
ON PersonalDetails

This will disable the trigger named “InsertAccounts” that is on PersonalDetails 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 PersonalDetails table, this trigger won’t fire.

 Views: 1106 | Post Order: 115



Write for us