What are the challenges you face when working across database platforms? Take the survey

Best strategy for dealing with triggers....

Brett_from_McCoyBrett_from_McCoy Posts: 1 New member
edited August 17, 2018 5:01PM in SQL Data Compare
I have an older database that uses a fair number of triggers to complete some processes (marking header complete when all parts are completed etc...).

This seems to lead to problems when synchronizing tables. I get the  "Identiy Insert" error though it is not the identity of the table I am inserting into, but the error also mentions something about triggers.

Pretty much the second half of this.
When I disable DML Triggers, I still get the same error. Am I missing something?

This seems to be a problem even when the trigger itself doesn't actually insert anything at all, and isn't trying to insert anything that doesn't have the identity field filled in with a value.


Sign In or Register to comment.