Errors running script - Identity Range issue

Brian Donahue

Hello Marc,

Is the identity column involved marked as NOT FOR REPLICATION? This
seems to make a difference in the way that new identities are inserted into
the PK column.

Brian Donahue
Red Gate Technical Support

"Marc Cassuto" <____________mcassuto@baoinc.com_______> wrote in message
news:ApMfA1sVDHA.1520@server53...
> I have 2 SQL2K servers using merge replication to keep data current
between
> two offices. Something went wrong last week and 2 days worth of
> updates/inserts at the suscriber DB did not replicate to the publisher on
> serveral tables. Replication is currently working properly otherwise. SQL
> DataCompare correctly identified the articles and produced the script to
> repair but when executed I recieve an error stating that "the Identity
Range
> managed by replication is full and must be ubdated by a replication
agent".
> I restarted the agents and even tried using
Sp_adjustpublisheridentityrange
> procedure but I still get the same error. It does not appear to do ANY
> updates at all.
>
> Any suggestions on how I can get around this and get my tables back into
> convergence?
>
> Thank You
> _________mcassuto@baoinc.com______
>
>