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