Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Merge Replication Identity Issue

Status
Not open for further replies.

jmikow

Programmer
Mar 27, 2003
114
US
I have been working on setting up replication and I now realized that I need to have merge replication instead of transactional for a single table.

I have rebuilt my publications so that the transactional pub does not have the one table and created a merge pub for that table.

The table has an IDENTITY column which I set to "Yes (Not for Replication" which is what I thought it told me to do and what I thought I had read. This column is also the PK for the table.

Now when I try and insert a row into the table on the Subscription server it says that there is a duplicate key row.

I know I'm probably missing something simple, but I can't figure this out and I need to get it working ASAP.

Any help would be greatly appreciated!

Thanks,

Josh
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top