Iam receiving the below error from distribution agent
Command attempted:
if @@trancount > 0 rollback tran
(Transaction sequence number: 0x0003160400008152004B00000000, Command ID: 1)
Error messages:
Explicit value must be specified for identity column in table 'XYZ' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column. (Source: MSSQLServer, Error number: 545)
I have set IDENTITY_INSERT to OFF but I receive the message as
Cannot insert explicit value for identity column in table 'XYZ' when IDENTITY_INSERT is set to OFF.
Any Suggestions.