Article ID: 304706 - View products that this article applies to.
This article was previously published under Q304706
BUG #: 353367 (SHILOH_BUGS)
When the merge agent is running in continuous mode and is using automatic identity range handling, inserts on the publisher's table with identities may fail with the following message when the identity range is full:
Server: Msg 548, Level 16, State 2, Line 1
The identity range managed by replication is full and must be updated by a replication agent. The INSERT conflict occurred in database 'pubs', table 'Table1', column 'ident_t1'. Sp_adjustpublisheridentityrange can be called to get a new identity range.
The merge agent does not properly renew the identity range at the publisher.
You can work around this problem in the following ways:
For more information on handling identity values in replication, see the following topics in SQL Server 2000 Books Online: