Triggers, Service Broker, CDC or Change Tracking?
Posted
by Derek D.
on SQL Server Planet
See other posts from SQL Server Planet
or by Derek D.
Published on Wed, 31 Mar 2010 04:35:33 +0000
Indexed on
2010/03/31
4:43 UTC
Read the original article
Hit count: 676
Filed under:
design
When one trigger inserts into a table and that table also contains a trigger, this is a “nested trigger”. The reason that nested triggers are a concern is because the first call that performs the initial insert does not return until the last trigger in sequence is complete. In trying to circumvent this [...]
© SQL Server Planet or respective owner
