How to stop/start the recursive Or Nested triggers?
|
|
|
Question / Problem
|
How to stop/start the recursive Or Nested triggers?
|
Solution
|
Using sp_CONFIGURE system stored procedure we can solve this problem.
To STOP nested triggers:
Syntax:
The value 0 - stops nested triggers.
Value 1 - starts nested triggers again.
sp_CONFIGURE 'nested_triggers',0
GO
RECONFIGURE
GO
Now you can receive the following msg
'Configuration option 'nested triggers' changed from 1 to 0. Run the RECONFIGURE statement to install.'
To START nested triggers:
sp_CONFIGURE 'nested_triggers',1
GO
RECONFIGURE
GO
Now you can receive the following msg
'Configuration option 'nested triggers' changed from 0 to 1. Run the RECONFIGURE statement to install.'
|
Applies to |
|
Microsoft SQL Server 2005
|
Rank It |
|
