The current table I am having issues with has an Publisher Range Size of 10,000, but when I look at the constraint I only see 1000 for the range size at the publisher. I have tried running sp_adjustpublisheridentityrange and changing the Publisher Range Size to 12000 to kick start it, but it still will not change.

  • Are you trying to change the identity_range or the pub_identity_range? – SQLHound Nov 21 '16 at 18:49
  • pub_identity_range – Paul Nov 22 '16 at 14:38

I manually changed the identity fields with DBCC CHECKIDENT. No automated way or configuration to fix it.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.