Home Forums SQL Server 7,2000 T-SQL Trigger Problem RE: Trigger Problem
jcool
SSC Eights!
Points: 863
More actions
June 23, 2003 at 1:07 am
#462562
Look like you ran into a loop. Trigger triggers itself until 32-level nesting limit is exceeeded. Have a look at "TRIGGER_NESTLEVEL" in BOL, check out the sample and set trigger to return if nesting > 1.