A personal repository of random information in compensation for a fatigued biological computer
Breaded IT » MS Access / SQL Server reminders » SQL Server 2000: Nested Triggers
Recursive updates..
ALTER DATABASE pubs
SET RECURSIVE_TRIGGERS ON
Used this for self-referencing relationship
Triggers can only be nested to a maximum of 32 levels after which an error will occur.
The nest level of the trigger is held in @@nestlevel.