How to set the nested triggers option (Enterprise Manager)

How to Install SQL Server 2000

How To

How to set the nested triggers option (Enterprise Manager)

To set the nested triggers option

  1. Expand a server group.

  2. Right-click a server, and then click Properties.

  3. Click the Server Settings tab.

  4. Under Server behavior, select or clear the Allow triggers to be fired which fire other triggers (nested triggers) check box.

See Also

Using Nested Triggers