How to set the nested triggers option (Enterprise Manager)
From How to Install SQL Server 2000
How to set the nested triggers option (Enterprise Manager)
To set the nested triggers option
- Expand a server group.
- Right-click a server, and then click Properties.
- Click the Server Settings tab.
- Under Server behavior, select or clear the Allow triggers to be fired which fire other triggers (nested triggers) check box.