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

Article translations Article translations
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'

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.

Properties

Article ID: 269204 - Last Review: October 16, 2003 - Revision: 3.2
APPLIES TO
  • Microsoft SQL Server 2000 Standard Edition
Keywords: 
kbbug kbpending KB269204

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com