BUG: Unable to Change Identity Range of Publisher If You Use Auto Identity Range (310540)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
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.

REFERENCES

SQL Server 2000 Books Online; topics: "Managing Identity Values"; "Using NOT FOR REPLICATION"; "sp_adjustpublisheridentityrange"
Modification Type:MajorLast Reviewed:10/3/2003
Keywords:kbBug kbpending KB310540
©2003 Microsoft Corporation. All rights reserved.