I have Three tables namely Contact, Orderheader and
OrderItem. Contact is related to Orderheader via ContactID
and Orderheader is related to OrderItem via OrderID.
Now I have a Delete Trigger which sits on Contact and
deletes related rows in OrderHeader. And simarly on
OrderHeader there is a trigger which deletes related rows
in OrderItem. So the idea is that when you delete a
contact all related orderheader and orderitem rows are
removed. However I am finding that the trigger which sits
on the OrderHeader table only fires once, and I am left
with orphaned rows in the OrderItem Table.
I have checked that the Nested Triggers option is set on
the server options and I have also enabled Recursive
Triggers for the database.
We have SQL server 7 installed with Service Pack 2.
Any suggestions on how to resolve this issue would be
The Salvation Army - Australia Southern Territory