SQL SERVER – 2005 Understanding Trigger Recursion and Nesting with examples | Journey to SQL Authority with Pinal Dave

Trigger events can be fired within another trigger action. One Trigger execution can trigger even on another table or same table. This trigger is called NESTED TRIGGER or RECURSIVE TRIGGER. Nested triggers SQL Server supports the nesting of triggers up to a maximum of 32 levels. Nesting means that when a trigger is fired, it… Continue Reading...

Source: SQL SERVER – 2005 Understanding Trigger Recursion and Nesting with examples | Journey to SQL Authority with Pinal Dave