Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to setup our replication with a republisher. We, unfortunately, have some tables with an int PK IDENTITY and I am getting the following error when trying to create the publication.

SQL Server Management Studio could not create article 'tblAdminBusinessType'. (New Publication Wizard)


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


The republisher's republishing range obtained from its publisher is not large enough to allocate the specified @pub_identity_range.
The article 'tblAdminBusinessType' could not be added to the publication 'Stage_Connect'.
Changed database context to 'Stage_Connect'. (Microsoft SQL Server, Error: 20660)

I changed the Publisher range size to 100000 and the Subscriber range size to 100. What I am not understanding is why this even matters, this table is marked as download only at both the Primary Publisher and the Re-Publisher. It can't be updated anywhere BUT directly on the Primary so what's the issue.

Secondly, how do I overcome this? Do I just keep massaging the numbers till it works? What, specifically, is it looking for?


Thank you,

share|improve this question
up vote 2 down vote accepted

Take a look at this MSDN forum post - it shows you how to make educated guesses as to what the ranges need to be.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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