"Shweta" <Shweta@discussions.microsoft.com> wrote in message
news:697E3FFF-8A77-4FC1-ABCE-747679F84DF3@microsoft.com...
> Hello,
>
> I've merge replication set between SQL Server 2000 & SQL CE.
> Whenever I try to add filter clause to the existing publication, it gives
> error mentioning the column name used in the filter clause.
>
> Ex. Let's say I've 5 publications - Pub1, Pub2, Pub3, Pub4, Pub5.
> If I add filter clause say 'Employee_Status <> 0' then it throws the error
> as 'Invalid Column Name 'Employee_Status'' even if that column is present
in
> the table.
>
> But, if I drop all publications (pub1 to pub5), then the whole thing works
> perfectly fine. But it is not feasible to drop ALL publications (even the
> ones not related to this change) to change the filter clause of 1 article
for
> just 1 publication. Is there any way out other than dropping the
publications?
>
> Thanks in advance for help.
>
> Regards,
> Shweta