August 17, 2009 at 2:45 pm
I am getting following error, when I try to run a Trans. Replication
Cannot insert explicit value for identity column in table 'DExtnCallDetail' when IDENTITY_INSERT is set to OFF.
my replication is using only one table and that table have a primary key
August 17, 2009 at 3:06 pm
Does you table have an Identity column?
Regards,Yelena Varsha
August 17, 2009 at 3:07 pm
this error occurs when you try to insert a value for the identity column in a table that has the identity property set.
If you set up replication, do not replicate the identity column, or remove it from the subscriber.
August 17, 2009 at 3:20 pm
when I delete the column and run the replication I got invalid column error
August 17, 2009 at 3:46 pm
You should not be deleting the column. You may just remove Identity property from the destination or try to enable Identity Insert.
Read this:
http://www.simple-talk.com/content/print.aspx?article=196
The identity crisis in replication
05 July 2005
by Hilary Cotter
Regards,Yelena Varsha
August 17, 2009 at 3:48 pm
I already remve the primary key, but still replication is not working, I am getting following error
"Error executing a batch of commands. Retrying individual commands"
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply