BUG: The Addition of a Merge Article with a Subset Filter Might Cause the Snapshot Agent to Fail (269204)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q269204
BUG #: 234987(SHILOH)

SYMPTOMS

When all of the following conditions are met:
  • The sp_addmergearticle stored procedure has a subset filter clause defined.

  • The new article does not have a rowguid column.

  • Snapshot files for the existing publication were ready before this article.
When you add an article to a pre-existing merge publication by using the sp_addmergearticle stored procedure, the Snapshot Agent might fail and the following error message occurs:
Invalid column name 'rowguid'

WORKAROUND

To work around this problem:

  1. Add a rowguid column to the article by using the following code:
    sp_MSaddguidindex 'publication_name', 'table_owner', 'table_name'
  2. Re-start the Snapshot Agent.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbBug kbpending KB269204
©2003 Microsoft Corporation. All rights reserved.