Microsoft KB Archive/310540

= BUG: Unable to Change Identity Range of Publisher If You Use Auto Identity Range =

Article ID: 310540

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q310540



BUG #: 355354 (SHILOH_BUGS)



SYMPTOMS
If you set up a table and you use Auto Identity Range to manage the table, you cannot use SQL Enterprise Manager or the sp_changemergearticle stored procedure to change the publisher's range.



WORKAROUND
To change the range on the publisher, you must drop and then re-create the publication with the new range.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

