Can you "Pause" or "Stop" a trigger from firing without dropping it?

[former_SQLA_member1694868]

I have plenty of tables that have triggers on them to update new inserts with supporting information.

Example - Insert into child table tableX with basic information, grabs information from parent table tableY and adds to the child record. These fields are then filled in with the defaults from the Parent for ease of use, but can be overridden at the child level rather than strictly inherited.

The issue is that there are also plenty of tables where the insert already has all the information (e.g. copy existing rows to a new year, copy from an existing system etc.)

Is there any syntax or feature that would behave similar to this:

Insert into tableX on existing skip with auto name NO TRIGGERS / PAUSE TRIGGERS

?

[MarkCulp · Accepted solution]

No, but you can program for this situation. See my other answer on this topic.

[former_SQLA_member1694868 · Accepted solution]

I knew I had seen it before, just couldn't find it in the search. Thanks Mark!