882
Part VII: Monitoring and Auditing
FIGURE 36-1
Object Explorer lists all triggers for any table and may be used to modify the trigger using
the context menu.Best Practice
When planning triggers, consider the most likely path. If the trigger verifi es data that will nearly always
be accepted, then an AFTER trigger is optimal. In this case the trigger is merely a check.For inserts, updates, or deletes that are rarely accepted, use an INSTEAD OF trigger, which substitutes
the DML statement’s work.c36.indd 882c36.indd 882 7/31/2012 10:03:07 AM7/31/2012 10:03:07 AM
http://www.it-ebooks.info