Microsoft KB Archive/269204

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

Article ID: 269204

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



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:

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



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

Additional query words: sync, initialization, row, horizontal, filter, sp_MSpublicationview

Keywords: kbbug kbpending KB269204

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.