Configure NESTED TRIGGERS ON at server/instance level

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 179
The deafult behaviour of NESTING TRIGGERs is OFF in database...

If you want to make it to ON at server level or instance level, the below code snippet will be useful

EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE ;
GO
EXEC sp_configure 'nested triggers', 1 ;
GO
RECONFIGURE;
GO

Comments or Responses

Login to post response