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: 7779 | Post Order: 115

Ask SQL Server question

Report Error