Post reply

Replication automatic identity ranges overlap

  • October 10, 2012 at 7:30 am

    #282989

    Hi,

    I have a transactional replication setup (with updateable subscribers) and after a reinitialization the auto identity ranges have managed to somehow overlap.

    The auto identity ranges are in increments of 1000 yet when i check the constraints on the published table the ID range is >30572 and <200000. The subscriber has a constraint range of 30140 - 31140.

    Is there any way I can change the constraint on the publisher? Ive tried sp_adjustpublisheridentityrange but its had no effect.

    Thanks,

    John

  • October 10, 2012 at 7:36 am

    #1547652

    FYI its SQL 2k8 R2 Standard at publisher and 2k8 Workgroup on Subscriber. This also appears to be the only article in the whole publication that has this issue.

    I am able to reinitialize if required although i would like to avoid having to do that.

    John

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply