892
Part VII: Monitoring and Auditing
■ (^) Audit trail
■ Modifi ed date
■ (^) Complex security
Nested Triggers
Trigger nesting refers to whether a DML trigger can cause another trigger to fi re. For example,
if the Nested Triggers server option is enabled, and a trigger updates TableA, and TableA
also has a trigger, then any triggers on TableA can also fi re, as shown in Figure 36-2.
FIGURE 36-2
The Nested Triggers confi guration option enables a DML statement within a trigger to fi re
additional triggers.
By default, the Nested Triggers option is enabled. Use the following confi guration command
to disable trigger nesting:
c36.indd 892c36.indd 892 7/31/2012 10:03:08 AM7/31/2012 10:03:08 AM
http://www.it-ebooks.info