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

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.
(https://support.microsoft.com/en-us/help/908711/you-receive-an-explicit-value-must-be-specified-for-identity-column-er)
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.
Tagged:

Answers

Sign In or Register to comment.