You are currently offline, waiting for your internet to reconnect

FIX: sp_addmergearticle May Fail with Error 20009 if Article Added Is Vertically Filtered

This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 236010 (SHILOH_BUGS)
Symptoms
Adding an article to a publication using sp_addmergearticle may result in the following error:
Msg 20009, Level 16, State 1, Server 'servername', Procedure sp_addmergearticle, Line 1202
The article 'articlename' could not be added to the publication 'publicationname'.
This error can occur if all the following conditions are true:
  • The article has a vertical filter.
  • The article does not already have a uniqueidentifier column with the ROWGUIDCOL property enabled.
  • The article has a identity column where:
    1. The identity column is included in the vertical partition. (For example, if the identity column is a primary key column, it will automatically be included in the filter.)
    2. The identity column is set up to handle identity range across all replicas (@auto_identity_range='true').
    3. The Not for Replication property is not set for the identity column.
Resolution
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack
Workaround
To work around this problem, you can do either of the following things before sp_addmergearticle is run:
  • Manually set the Not For Replication property on the identity column. -or-

  • If there is a uniqueidentifier column already in the table, enable the ROWGUIDCOL property for that column. If there is not a uniqueidentifier column, add a new column called "rowguid" with datatype uniqueidentifier and the ROWGUIDCOL property set.
Status
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.
Properties

Article ID: 300172 - Last Review: 01/16/2015 22:50:34 - Revision: 4.0

  • Microsoft SQL Server 2000 Standard Edition
  • kbnosurvey kbarchive kbbug kbfix kbsqlserv2000sp1fix KB300172
Feedback