伺服器觸發程序遞迴伺服器組態選項server trigger recursion Server Configuration Option

適用於: 是SQL Server 否Azure SQL Database 否Azure Synapse Analytics (SQL DW) 否平行處理資料倉儲 APPLIES TO: yesSQL Server noAzure SQL Database noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

使用 [伺服器觸發程序遞迴] 選項,可指定是否允許伺服器層級的觸發程序以遞迴方式引發。Use the server trigger recursion option to specify whether to allow server-level triggers to fire recursively. 如果此選項設成 1 (ON),則允許伺服器層級的觸發程序以遞迴方式引發。When this option is set to 1 (ON), server-level triggers will be allowed to fire recursively. 若設成 0 (OFF),則伺服器層級的觸發程序無法以遞迴方式引發。When set to 0 (OFF), server-level triggers cannot be fired recursively. 當 server trigger recursion 選項設為 0 (OFF),只能阻止直接遞迴。Only direct recursion is prevented when the server trigger recursion option is set to 0 (OFF). (若要停用間接遞迴,請將 [巢狀觸發程序] 選項設定為 0)。這個選項的預設值是 1 (ON)。(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) RECONFIGURE (Transact-SQL)
伺服器組態選項 (SQL Server) Server Configuration Options (SQL Server)
sp_configure (Transact-SQL)sp_configure (Transact-SQL)