Stop Insert Trigger Firing

[Craig0201]

Hi,

I have an insert trigger which changes some data and records an entry in a log table. The changes cause the update trigger which records a further entry in the log file. How can I stop the update trigger from firing when the data is changed by the insert trigger?

Craig

 

[Craig0201]

Helps if you look more closely before you ask.

sp_configure 'nested triggers',0 at the top of the insert trigger and sp_configure 'nested triggers',1 at the bottom.

Craig