Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003

    Question Unanswered: Replication Failed to enumerate changes in the filtered articles

    For the past couple of month, our replication merge agent will pop out a "Failed to enumerate changes in the filtered articles" error once a while. Does anyone know what maybe the cause or how to fix it?

    Restarting the server seem to temporarily fix the problem, but the error will show up after a one or two month.

    Will appreciate any advices.

    Error Detail:
    Failed to enumerate changes in the filtered articles.
    (Source: Merge Replication Provider (Agent); Error number: -2147200925)
    Line 1: Incorrect syntax near '-'.
    (Source: CMMASTER (Data source); Error number: 170)

  2. #2
    Join Date
    Aug 2002
    Try to re-define the articles and see the results.
    --Satya SKJ
    Microsoft SQL Server MVP

  3. #3
    Join Date
    Oct 2004

    Merge Agent failed to enumerate filtered articles


    There's an Microsoft article on this with reference to a hotfix if the problem persists:;en-us;814916

    I've just applied myself but haven't been able to test whether it has resolved the problem or not.

    Good luck.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts