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.