Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize


Product Name

SQL Server

Product Version


Product Build Number


Event ID


Event Source



SQL Server Database Engine

Symbolic Name

Message Text

The merge process failed to enumerate changes in articles with parameterized row filters. If this failure continues, increase the query timeout for this process, reduce the retention period for the publication, and improve indexes on published tables.

This error is raised if a Merge Agent timeout occurs while processing changes in a filtered publication. The timeout might be caused by one of the following issues:

  • Not using the precomputed partitions optimization.

  • Index fragmentation on columns used for filtering.

  • Large merge metadata tables, such as MSmerge_tombstone, MSmerge_contents, and MSmerge_genhistory.

  • Filtered tables that are not joined on a unique key and join filters that involve a large number of tables.

To resolve the issue:

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft