"Warren Patterson" <des@newsgroups.nospam> wrote in message
news:eYSANebNFHA.2468@tk2msftngp13.phx.gbl...
> Hi,
>
> I am using Merge Replication and the subscriber is a pull subscriber.
>
> Some tables are filtered, in the publication properties, if I go to FILTER
> ROWS, then FILTER CLAUSE column, some tables are filtered like so
> depot_system_id = 'xxxxx-xxxxx-xxxxx-xxxxxx' where x makes up the guid.
>
> The replication objects are owned by DBO.
>
> Versions of SQL:
>
> Publisher:
> ----------
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: )
>
> Subscriber:
> -----------
> MSDE
>
>
> Everything was working fine, then all of a sudden, I get this error. (See
> below)
> Does anyone know what would cause this and how I can overcome it?
>
> Thanks in Advance
> Warren
>
> ***************************************************
> ******************ERROR DETAILS******************
> ***************************************************
> Last command: {call sp_MSsetupbelongs(?,?,?,?,?,1,?,?,1,?,?,?,?,?,?)}
>
> Error Message: Failed to enumerate changes in the filtered articles.
>
> Error Details:
>
> Failed to enumerate changes in the filtered articles.
> (Source: Merge Replication Provider (Agent); Error number: -2147200925)
> --------------------------------------------------------------------------
--
> -----------------------------------
> Incorrect syntax near the keyword 'where'.
> (Source: GENCENTRIC_SVR1 (Data source); Error number: 156)
> --------------------------------------------------------------------------
--
> -----------------------------------
> Incorrect syntax near the keyword 'and'.
> (Source: GENCENTRIC_SVR1 (Data source); Error number: 156)
> --------------------------------------------------------------------------
--
> -----------------------------------
> ***************************************************
> *******************END OF ERROR******************
> ***************************************************
>
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:eYPCVpeNFHA.508@TK2MSFTNGP12.phx.gbl...
> Someone reported a similar problem and solved it by reapplying sp3a.
>
>
http://groups-beta.google.com/group/microsoft.public.sqlserver.replication/browse_frm/thread/f7cfa9418c7f08c/376e3a5eb8c1ea7a?q=sp_MSsetupbelongs+Failed+to+enumerate+changes+in+the+filtered+articles&rnum=4#376e3a5eb8c1ea7a
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Warren Patterson" <des@newsgroups.nospam> wrote in message
> news:eYSANebNFHA.2468@tk2msftngp13.phx.gbl...
> > Hi,
> >
> > I am using Merge Replication and the subscriber is a pull subscriber.
> >
> > Some tables are filtered, in the publication properties, if I go to
FILTER
> > ROWS, then FILTER CLAUSE column, some tables are filtered like so
> > depot_system_id = 'xxxxx-xxxxx-xxxxx-xxxxxx' where x makes up the guid.
> >
> > The replication objects are owned by DBO.
> >
> > Versions of SQL:
> >
> > Publisher:
> > ----------
> > Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> > Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
> > Standard Edition on Windows NT 5.2 (Build 3790: )
> >
> > Subscriber:
> > -----------
> > MSDE
> >
> >
> > Everything was working fine, then all of a sudden, I get this error.
(See
> > below)
> > Does anyone know what would cause this and how I can overcome it?
> >
> > Thanks in Advance
> > Warren
> >
> > ***************************************************
> > ******************ERROR DETAILS******************
> > ***************************************************
> > Last command: {call sp_MSsetupbelongs(?,?,?,?,?,1,?,?,1,?,?,?,?,?,?)}
> >
> > Error Message: Failed to enumerate changes in the filtered articles.
> >
> > Error Details:
> >
> > Failed to enumerate changes in the filtered articles.
> > (Source: Merge Replication Provider (Agent); Error number: -2147200925)
>
> --------------------------------------------------------------------------
> --
> > -----------------------------------
> > Incorrect syntax near the keyword 'where'.
> > (Source: GENCENTRIC_SVR1 (Data source); Error number: 156)
>
> --------------------------------------------------------------------------
> --
> > -----------------------------------
> > Incorrect syntax near the keyword 'and'.
> > (Source: GENCENTRIC_SVR1 (Data source); Error number: 156)
>
> --------------------------------------------------------------------------
> --
> > -----------------------------------
> > ***************************************************
> > *******************END OF ERROR******************
> > ***************************************************
> >
> >
> >
>
>