Best strategy for dealing with triggers....
Brett_from_McCoy
Posts: 1 New member
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.
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
Can you please confirm the version number of your SQL Server as well as SQL Data Compare?
Can you post a screenshot of the error? When did you get this error (registering db, comparison or deployment)?
Tianjiao Li | Redgate Software
Have you visited our Help Center?