Publication Filter Clause changes

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
exactly how are you deploying your publication to your SQL CE clients?
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"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