What should the publication range and subscription range be set to for each table with identity ranges, bearing in mind thousands of changes can go into some tables each day. I have 1 Publisher and 9 Subscriptions (Merge) and have started getting "The Publisher failed to allocate a new set of identity ranges for the subscription.""Error number: MSSQL_REPL-214719941"
Is there a formula or Rule-of-thumb that we can use?
March 11, 2008 4:41 PM
March 11, 2008 8:16 PM