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

    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
    Location
    Scotland
    Posts
    1,578
    Try to re-define the articles and see the results.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Oct 2004
    Posts
    1

    Merge Agent failed to enumerate filtered articles

    Hi,

    There's an Microsoft article on this with reference to a hotfix if the problem persists:

    http://support.microsoft.com/default...b;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.

    A

Posting Permissions

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