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.