<div>
make the changes at subsriber and see if it works.<br />
<br />
also always test on dev.<br />
<br />
HTH<br />
Vinay
</div>


make the changes at subsriber and see if it works.

also always test on dev.

HTH
Vinay

<div>
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?
</div>


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?

<div>
Got the solution form Microsoft support site
</div>


Got the solution form Microsoft support site

<div>
<div class="content wysiwyg-content">
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_adjustpublisheridentity<wbr />range also but i was unlucky. Why does the publisher not assigning any new identity range for the subscriber?<br />
<br />
Many Thanks
</div>
</div>


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

Merge Replication Identity Range not updating

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.