Prev: Maximum Retention period of the distributor DB (transactional repl
Next: Schema Only Snapshot
From: Steve on 28 Aug 2008 22:20
I have SQL Server 2000 build 8.00.908 and one of my Merge publications has
developed the error "failed to enumerate changes in the filtered articles".
Further details give the following msgs: "Incorrect syntax near the keyword
'where' and "incorrect syntax near the keyword 'and' ". The last command
field displays {call sp_MSsetupbelongs(?,?,?,?,?,1,?,?,1,?,?,?,?,?,?)}.

I have 3 subscribers to this publication and they all get the same error
msg. This publication has been working for quite some time w/o problems and
started giving this err msg suddenly, w/o any chgs being made to it. The
publication has row filtering. All of my other publications are doing fine
and most of them have row filtering as well. I hate to create a new
publication because my subscribers would have to reinitialize and they are
quite a long distance from me.

Any ideas what I can do?


thanks in advance.

Steve
 | 
Pages: 1
Prev: Maximum Retention period of the distributor DB (transactional repl
Next: Schema Only Snapshot