Hello!

I have a small issue with an AFTER UPDATE Triger I implemented on one table of my db. In my trigger, I do some validation and update others (not in inserted or deleted) rows of my table. Thoses rows are updated but are not triggering my trigger (similar to a controlled loop). I'm wondering if there's a way to get them running the same trigger.

I have a situation of child / parent in my rows sometimes. If I'm updating a child, I need the parent to be updated and validated. A child is not very at all and I really needs the parent to be the one who makes the "call".

Is it feasible?

Thanks

Please post the exact case with table structure and trigger code.

I found the issue, I needed to add a recursive triggers options in Database option which is defaulted to false.

I spend a lot time finding that info and honestly it's a normal comportement to eliminate the risk of endless looping.

I hope it's clear for anyone searching for that kind of issue.

The info is here: http://msdn.microsoft.com/en-us/libr...4(SQL.80).aspx