Limiting Trigger Nesting : sp_configure « System Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. System Functions
  3. sp_configure
3>
4> USE master
5> GO
Changed database context to 'master'.
1> -- Disable nesting
2> EXEC sp_configure 'nested triggers', 0
3> RECONFIGURE WITH OVERRIDE
4> GO
Configuration option 'nested triggers' changed from 1 to 0. Run the RECONFIGURE statement to install.
1> -- Enable nesting
2> EXEC sp_configure 'nested triggers', 1
3> RECONFIGURE WITH OVERRIDE
4> GO
Configuration option 'nested triggers' changed from 0 to 1. Run the RECONFIGURE statement to install.
1>
2>








25.27.sp_configure
25.27.1.Limiting Trigger Nesting
25.27.2.Changing SQL Server Configurations
25.27.3.sp_configure [configname[,configvalue]]
25.27.4.EXEC sp_configure 'allow updates', 1