How can I resolve a circular dependancy issue?

wendyc

Hi All

I don't really expect an answer tonight, but I'm trying to recover about 4 hours worth of data from a live system and am getting a circular dependancy warning on my data compare. I've got many many rows to push back to the live system ( backup of data after corruption to restored database) Anyone have a script handy that can illuminate where the circularity is?

Eddie D

Thank you for your post into the forum.

Do you have an further information regarding the objects envolved in the circular dependency or dependencies?

I have known this problem to occur if you have update triggers enabled that cause actions that come back to the original object to be updated.

If you edit the project and select the options tab. Please enable the options to Disable DML Triggers and Disable DDL Triggers in the Synchronization Behavior Section.

Hope this helps.

Many Thanks
Eddie