Message Details

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.

User Action

To resolve the issue: