SQL Server/T-SQL Tutorial/Trigger/RECURSIVE TRIGGERS

Controlling Trigger Recursion

5>
6> -- Allows recursion
7> ALTER DATABASE YourDatabaseName
8> SET RECURSIVE_TRIGGERS ON
9> -- View the db setting
10> SELECT is_recursive_triggers_on
11> FROM sys.databases
12> WHERE name = "YourDatabaseName"
13> -- Prevents recursion
14> ALTER DATABASE YourDatabaseName
15> SET RECURSIVE_TRIGGERS OFF
16> -- View the db setting
17> SELECT is_recursive_triggers_on
18> FROM sys.databases
19> WHERE name = "YourDatabaseName"
20>
21>