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?


9 Years
Discussion Span
Last Post by drynish

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/library/aa258254(SQL.80).aspx

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.