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: 636

Filed under:
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

Related posts about design