触发器设置递归

--RECURSIVE_TRIGGERS 的设置 递归
ALTER DATABASE Platform_QuotaCompile6 SET RECURSIVE_TRIGGERS off;
--Nested triggers 的设置:嵌套
EXEC sp_configure 'nested_triggers', 0
RECONFIGURE WITH OVERRIDE

原文地址:https://www.cnblogs.com/zhangzhifeng/p/15016734.html