Microsoft SQL Server Desktop Engine - Replication: wrong ID assingment

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Replication: wrong ID assingment

mdiaz380

2005-11-15, 1:23 pm

Hi, all.
I'm running SQL Server 2000 and using Access 2000 as front end.
I created a transactional replication (for the moment I have 2
computers, one
is distributor and publisher, the other subscriber with MSDE)

In my tables I have an IDxxx field, and for the replication, SQL Server
has
added a GUID field.
To avoid collisions I chose "NOT VALID FOR REPLICATION" option and
define
range for the IDs for each subscriber.
Everything works fine from the point of view of replication but ID
assigment
at the subscriber:

When I create a record at the subscriber, the ID created is very low
and OUT
of the limits.

Can anyone give me some light?
Thanks

Sponsored Links