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
gdavidson-740471
Mr or Mrs. 500
Points: 562
More actions
March 17, 2009 at 11:38 am
#961268
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.