Failed to Enumerate Changes in the Filtered Articles -- sql server replication

chrisv NO[at]SPAM sharpesoft.com
9/13/2006 1:59:16 PM

We are receiving this error message when starting a merge agent.

Publisher/Distributor is MSSQL 2000 SP4.

Subscribers are MSDE 2000 SP4.

The error message in the Agent is "Syntax error near '-'"

Last command: create table #belong_agent_-1893386031 (tablenick int NOT
NULL, rowguid uniqueidentifier NOT NULL,generation int NULL, lineage
varbinary(255) NULL, colv varbinary(2048) NULL)

All of the information I have found on this error suggests that it is a
SQL Bug that was fixed in SP4. Have verified that the
Publisher/Distributor and the Subscribers are running SP4.
(http://support.microsoft.com/kb/814916/)

Anybody know what else could be causing this and how to correct it?
Replication was working fine for quite some time before the merge
agents started getting this error.

Merge Replication with Distributor configured on Publisher. 4 anonymous
subscriptions, all experience this problem on 100% of merge attempts.

Any help is greatly appreciated!

Hilary Cotter
9/13/2006 9:49:27 PM

There have been some instances where sp 4 does not apply completely. Can you
check the binaries to verify they have the same date stamp and size with
another installation with SP 4?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

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

[quoted text, click to view]

sql server replication : Failed to Enumerate Changes in the Filtered Articles