Failed to enumerate changes in filtered tables

I met the following error
Failed to enumerate changes in the filtered articles.
Category: NULL Source:
Merge Replication Provider
Number: -2147200925
Message: Failed to enumerate changes in the filtered
articles.
Category: COMMAND
Source: Failed Command
Number: 0
Message: create table #belong_agent_-2147483646
(tablenick int NOT NULL, rowguid uniqueidentifier NOT
NULL,generation int NULL, lineage varbinary(255) NULL,
col v varbinary(2048) NULL)
Category: SQLSERVER
Source: ServerName
Number: 170
Message: Line 1: Incorrect syntax near '-'.
I have visit the link :
http://support.microsoft.com/default.aspx?scid=kb;en-
us;814916#appliesto
but i found no help?
Can any body help me out of this stuck?
Thanks a lot
Please post here a script for creation of DB schema and publication creation
script. That would help us to help you
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"Mai Thoa" <anonymous@.discussions.microsoft.com> wrote in message
news:1ceb01c48cbd$18406f00$a301280a@.phx.gbl...
> I met the following error
> Failed to enumerate changes in the filtered articles.
> Category: NULL Source:
> Merge Replication Provider
> Number: -2147200925
> Message: Failed to enumerate changes in the filtered
> articles.
> Category: COMMAND
> Source: Failed Command
> Number: 0
> Message: create table #belong_agent_-2147483646
> (tablenick int NOT NULL, rowguid uniqueidentifier NOT
> NULL,generation int NULL, lineage varbinary(255) NULL,
> col v varbinary(2048) NULL)
> Category: SQLSERVER
> Source: ServerName
> Number: 170
> Message: Line 1: Incorrect syntax near '-'.
> I have visit the link :
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;814916#appliesto
> but i found no help?
> Can any body help me out of this stuck?
> Thanks a lot
|||Mai,
there is a reported issue for your situation:
http://support.microsoft.com/default...b;en-us;814916
hth,
Paul Ibison
|||Thanks Paul, But I'm wondering if the hot fix will help
me, cause it will cost for that hot fix :-(. Are there
any other reasons? The error I met does match the
description in your given link.
Thanks
Mai Thoa
>--Original Message--
>Mai,
>there is a reported issue for your situation:
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;814916
>hth,
>Paul Ibison
>
>.
>
|||Mai,
you could enable logging to get more info
(http://support.microsoft.com/?id=312292) or simply restart the merge
agent - this often removes the problem.
HTH,
Paul Ibison