Error "...could not enumerate changes.." Incorrect syntax ... 'a

Error in replication Merge:
{call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
The process could not enumerate changes at the 'Subscriber'.
(Source: Merge Replication Provider (Agent); Error number: -2147200999)
Incorrect syntax near the keyword 'and'.
(Source: SERVIDOR (Data source); Error number: 156)
I already altered the store procedure sp_MSenumchanges/sp_MSenumchanges_Pal
and sp_MSenumchanges_Direct var @.genlist
and the mistake continues.
Please help me
Hamilton
SP, Brazil
Try installing the service pack 2 or above.
this usually happens when a column contains images.
"Hamilton" <Hamilton@.discussions.microsoft.com> wrote in message
news:CC77034E-D903-4552-8501-910B96E6D519@.microsoft.com...
> Error in replication Merge:
> {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> The process could not enumerate changes at the 'Subscriber'.
> (Source: Merge Replication Provider (Agent); Error number: -2147200999)
> Incorrect syntax near the keyword 'and'.
> (Source: SERVIDOR (Data source); Error number: 156)
> I already altered the store procedure
> sp_MSenumchanges/sp_MSenumchanges_Pal
> and sp_MSenumchanges_Direct var @.genlist
> and the mistake continues.
> Please help me
> Hamilton
> SP, Brazil
|||Try using Profiler to capture which exactly SQL statement in which procedure
is failing. That should give a hint what could be wrong.

> I already altered the store procedure
sp_MSenumchanges/sp_MSenumchanges_Pal
> and sp_MSenumchanges_Direct var @.genlist
> and the mistake continues.
What have you changed in those procedures ? For what reason ?
Regards,
Kestutis Adomavicius
Consultant
UAB "Baltic Software Solutions"
"Hamilton" <Hamilton@.discussions.microsoft.com> wrote in message
news:CC77034E-D903-4552-8501-910B96E6D519@.microsoft.com...
> Error in replication Merge:
> {call sp_MSenumchanges(?,?,?,?,?,?,?,?)}
> The process could not enumerate changes at the 'Subscriber'.
> (Source: Merge Replication Provider (Agent); Error number: -2147200999)
> Incorrect syntax near the keyword 'and'.
> (Source: SERVIDOR (Data source); Error number: 156)
> I already altered the store procedure
sp_MSenumchanges/sp_MSenumchanges_Pal
> and sp_MSenumchanges_Direct var @.genlist
> and the mistake continues.
> Please help me
> Hamilton
> SP, Brazil