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.