| title | server trigger recursion Server Configuration Option | Microsoft Docs | |||
|---|---|---|---|---|
| description | Learn how the "server trigger recursion" option affects recursion in SQL Server server-level triggers. See how to turn direct and indirect recursion on and off. | |||
| ms.custom | ||||
| ms.date | 03/02/2017 | |||
| ms.prod | sql | |||
| ms.prod_service | high-availability | |||
| ms.reviewer | ||||
| ms.technology | configuration | |||
| ms.topic | conceptual | |||
| helpviewer_keywords |
|
|||
| ms.assetid | da4c25f5-d04c-4951-a3db-409e71a1b468 | |||
| author | markingmyname | |||
| ms.author | maghan |
[!INCLUDE SQL Server]
Use the server trigger recursion option to specify whether to allow server-level triggers to fire recursively. When this option is set to 1 (ON), server-level triggers will be allowed to fire recursively. When set to 0 (OFF), server-level triggers cannot be fired recursively. Only direct recursion is prevented when the server trigger recursion option is set to 0 (OFF). (To disable indirect recursion, set the nested triggers option to 0.) The default value for this option is 1 (ON). The setting takes effect immediately (without a server restart).
For more information, see Create Nested Triggers.
RECONFIGURE (Transact-SQL)
Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)