We have been struggling with exhausting our range and get the following error:
The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a Publisher or a republishing Subscriber has run out of identity ranges to allocate to its own Subscribers or when an identity column data type does not support an additional identity range allocation. If a republishing Subscriber has run out of identity ranges, synchronize the republishing Subscriber to obtain more identity ranges before restarting the synchronization. If a Publisher runs out of identity (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199417). Get help: http://help/MSSQL_REPL-2147199417
Not enough range available to allocate a new range for a subscriber. (Source: MSSQLServer, Error number: 20668)
We have a Publication that has 9 subscribers who make thousands of record changes daily and have run in to the identity range problem.
Thanks for your help...
March 17, 2008 2:31 PM
March 18, 2008 4:18 PM