How to set the nested trigger option (Enterprise Manager)
To set the nested trigger option
Expand a server group.
Right-click a server; then click Properties.
Click the Server Settings tab.
In the Server behavior box, select or clear Allow triggers to be fired which fire other triggers (nested triggers).