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


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'


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.


Microsoft has confirmed this to be a problem in SQL Server 2000.


Article ID: 269204 - Last Review: October 16, 2003 - Revision: 3.2
  • Microsoft SQL Server 2000 Standard Edition
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