Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replication Issue

Author  Topic 

lupo
Starting Member

2 Posts

Posted - 2005-10-08 : 12:42:52
Hi all,

I'm trying to manage a merge replication between two devices: a PC (Publisher) and a Pocket PC (Subscriber). Let's suppose there is only one table into the db:

T_Ex
ID (Identity column 1,1), Description

and there are three records inserted into the publisher's db (1, 'aaa' - 2, 'bbb' - 3, 'ccc'). When the subscriber synchronize itself to the publisher and then I try to insert a new record from the pocket pc, I got the last record inserted with ID = 1 resulting in an error cause there was already a record with ID = 1. It seems that the identity value in the subscriber's table is reseed to 1. How can I manage identity replication?
Thanks in advance!

lupo
Starting Member

2 Posts

Posted - 2005-10-12 : 06:41:47
anybody there?
Go to Top of Page
   

- Advertisement -