Controlling Trigger Recursion : RECURSIVE_TRIGGERS « Trigger « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Trigger
3. RECURSIVE_TRIGGERS

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>