Microsoft KB Archive/255688

From BetaArchive Wiki
Knowledge Base

FIX: Static Filtered Merge Publications Take Long Time to Synchronize

Article ID: 255688

Article Last Modified on 3/14/2006


  • Microsoft SQL Server 7.0 Standard Edition

This article was previously published under Q255688

BUG #: 56831 (SQLBUG_70)


Prior to SQL Server 7.0 Service Pack 2 (SP2), creating the snapshot files in Merge Replication for publications, by using the static filters, might take a considerable amount of time depending on the data modification activity on the table(s) included in the articles, regardless of the filter criteria specified.

The Snapshot files include a BCP data file for the MSMerge_contents table. This fix applies the filter criterion to the contents of the MSMerge_contents table, reducing the size of the BCP file significantly, depending on the contents of the table and the filter conditions. In many cases, this vastly improves performance of the initial snapshot. Also, if you are using JOIN filters, appropriate indexes on the JOIN columns also help considerably to improve performance.


Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack 2 for Microsoft SQL Server 7.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

254561 INF: How to Obtain Service Pack 2 for Microsoft SQL Server 7.0 and Microsoft Data Engine (MSDE) 1.0

For more information, contact your primary support provider.

Additional query words: snapshot filter Merge replication

Keywords: kbbug kbfix KB255688