I am having a problem using the SQL Server 2000 automated
identity value management facility. I have 2 SQL Server
2000 dbs and using merge replication. For articles with
tables having identity I use automatic allocation with 100
value blocks and an 80 threshold (the default values). The
problem is that on the publisher, the next block of values
is never allocated. Even when the threshold is crossed and
AFTER the merge process runs and replicates the new rows,
the next value does not jump to the next block and all the
remaining values are used. Then of course, this happens:
The identity range managed by replication is full and must
be updated by a replication agent. The INSERT conflict
occurred in database <table names etc. deleted> .
Sp_adjustpublisheridentityrange can be called to get a new
Calling the stored procedure fixes the problem but this
hardly makes it automated. Also, this is NOT a problem on
the subscriber. When it allocates identity values past the
threshold, it moves to the next block after the merge runs.
I have installed SP1 on both of these servers.
Has anyone else experienced this? Does anyone have a
Thanks in advance...