I am Running SQL Server 2000 with merge replication
I have a table that looks something like this...
OrderID - NVARCHAR(50)
LineNumber - BigInt - Identity +1 increment
I have both of these columns set up as the primary key, but for some reason replication is occasionally deleting these records because of a primary key constraint violation on the subscriber. I understand why replication has to delete the records, but I just don't know why there would be an existing record on the subscriber. If were happening every time, that would be one thing, but it's only happening about once out of every 1,000 records. Can anyone offer some advice on how to track down why I am getting these violations?
These records are only being added by an application that only connects to the publisher, so I know that nobody is adding records manually to the subscriber.