FIX: Merge Initial Sync With Dynamic Filters Takes Long Time to Synchronize

Article translations Article translations
Article ID: 224329 - View products that this article applies to.
This article was previously published under Q224329
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 53994 (SQLBUG_70)
Expand all | Collapse all

Symptoms

When working with Merge publications, which have Dynamic Filtering, the initial synchronization takes a long time to complete. This is because of the need to generate metadata for all rows at snapshot time, trying to eliminate the rows that will not be sent to this subscriber. This results in protracted initial sync times for large tables even though the subscriber receives only a small subset of the data. The problem does not occur if no horizontal (rows) filtering is involved.

Status

Microsoft has confirmed this to be a problem in SQL Server 7.0. This problem has been corrected in U.S. Service Pack SP1 for Microsoft SQL Server 7.0. For information about how to download and install the latest SQL Server Service Pack, see the following Microsoft Web site:
http://www.microsoft.com/sql/prodinfo/previousversions/downloads/servicepacks.mspx
For more information, contact your primary support provider.

Properties

Article ID: 224329 - Last Review: November 2, 2013 - Revision: 4.0
Applies to
  • Microsoft SQL Server 7.0 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix kbqfe KB224329

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