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

Article ID: 269204 - View products that this article applies to.
This article was previously published under Q269204
BUG #: 234987(SHILOH)
Expand all | Collapse all

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'
Back to the top | Give Feedback

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.
Back to the top | Give Feedback

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.
Back to the top | Give Feedback

Properties

Article ID: 269204 - Last Review: October 16, 2003 - Revision: 3.2
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbbug kbpending KB269204
Back to the top | Give Feedback

Give Feedback

 
Back to the topBack to the top