Skip to content

Latest commit

 

History

History
38 lines (33 loc) · 1.85 KB

File metadata and controls

38 lines (33 loc) · 1.85 KB
title server trigger recursion Server Configuration Option | Microsoft Docs
ms.custom
ms.date 03/02/2017
ms.prod sql-non-specified
ms.prod_service database-engine
ms.service
ms.component configure-windows
ms.reviewer
ms.suite sql
ms.technology
database-engine
ms.tgt_pltfrm
ms.topic article
helpviewer_keywords
recursive triggers [SQL Server]
triggers [SQL Server], recursive
server trigger recursion option
ms.assetid da4c25f5-d04c-4951-a3db-409e71a1b468
caps.latest.revision 24
author BYHAM
ms.author rickbyh
manager jhubbard
ms.workload Inactive

server trigger recursion Server Configuration Option

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

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.

See Also

RECONFIGURE (Transact-SQL)
Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)