• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 442
  • Last Modified:

Merge Replication Identity Range not updating

I have a merge replication running between 7 SQL Server 2000, and the identity management is configured as Automatic. Now the problem is that, at one of our subscriber the identity range of a table get filled up its range and the publisher is not assigning or updating new values to that table. I tried sp_adjustpublisheridentityrange also but i was unlucky. Why does the publisher not assigning any new identity range for the subscriber?

Many Thanks
0
Anuj
Asked:
Anuj
  • 3
1 Solution
 
ThakurVinayCommented:
make the changes at subsriber and see if it works.

also always test on dev.

HTH
Vinay
0
 
AnujAuthor Commented:
Vinay, I manually assigned new ranges to the subscriber and is working fine. But my question is why publisher doesn't assigned any new values to the subscriber?
0
 
AnujAuthor Commented:
When the merge agent is running continuously at times new identity ranges are not assigned and this is reported as a bug in SQL Server 2000.

The work around is to manually restart the merge agent or schedule the merge agent to run every minute or so

BUG: Identity Range Not Adjusted on Publisher When Merge Agent Runs Continuously
0
 
AnujAuthor Commented:
Got the solution form Microsoft support site
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now