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
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