Home Forums SQL Server 2005 T-SQL (SS2K5) Insert trigger not working when update trigger enabled RE: Insert trigger not working when update trigger enabled

  • Yes - but I am using the trigger with a third party applications database so I am not sure that I can turn off recursive triggers as that is a global setting. Hence the use of trigger_nestlevel to check the recursion depth.