Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Subscriber not updated when filtering a publication on a bit type field

0 views
Skip to first unread message

news...@adaml.net

unread,
Feb 27, 2007, 5:10:17 PM2/27/07
to
Hi

I'm new to replication and would really appreciate any help with this
problem.

I've set up a transactional publication with one table and a filter on
an 'int' type field.

When I update a qualifying record on the publisher, the subscriber
updates immediately as I would expect.

However, if I change the filter to a 'bit' type field and
reinitialise, the initial snapshot filters correctly and the correct
rows are sent to the subscriber , but subsequent changes to fields on
the publisher are not replicated to the subscriber.

Thanks

0 new messages