Purpose

The purpose of this article is to teach you the process of setting up the nested triggers option in Microsoft SQL Server 2000.

To Set the Nested Triggers Option

Triggers are nested when a trigger performs an action that initiates another trigger, which can initiate another trigger, and so on. Triggers can be nested up to 32 levels, and you can control whether triggers can be nested through the nested triggers server configuration option. If nested triggers are allowed and a trigger in the chain starts an infinite loop, the nesting level is exceeded and the trigger terminates.

Following steps describe you the step by step details of setting up the nested triggers option:

1. Click Start, then go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

2. Right click the registered SQL Server i.e. PC54, then click Properties, now click the Server Settings tab.

3. Select the Allow triggers to be fired which fire other triggers (nested triggers) option.

4. Click OK.