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