How to insert rows into a table without triggering the active insert trigger?

How to insert rows into a table without triggering the active insert trigger?

Post by Bruc » Wed, 30 Jul 2003 21:44:17


I got the following interview question which beats me:

How to insert rows into a table without triggering the
active insert trigger of this table?

Does anybody know the answer?

Thanks.
 
 
 

How to insert rows into a table without triggering the active insert trigger?

Post by Scott Morr » Wed, 30 Jul 2003 22:07:45

You can disable the trigger using alter table - syntax in BOL. Note that
this disables the trigger for everyone and that the trigger should be
re-enabled when you are done.