Very Computer

Hi everybody.

I am trying to replicate two databases that are on the same server (this is
a test). I use merge replication in MS SQL Server 7.0. I have created a
dynamic filter for the publication. This filter is based on the subscriber
username. The subscription I use is a Pull subscription.

The table I publish contains 3 columns : a global unique id, a user name,
and a text column.

I can add and insert rows in the publisher database and the changes appear
at the subscriber (if the added or updated rows contain the subscriber's
username). I can also add or update rows at the subcriber and the
modifications are updated at the publisher.

Now is the PROBLEM (or question).

Is it normal that ALL the rows that I add at the subscriber appear at the
publisher (even the ones that DO NOT contain the username used in the merge)
?

Also, is it normal that the rows added at the subscriber that do not contain
the username used in the filter are deleted at the subscriber?

I can't find these answers anywhere...

Thank you in advance for giving me the answers to my questions.

Hugues

What your witnessing is perfectly normal. Anything that
matches the filter stays there, otherwise it gets synced
to the publisher and removed from the subscriber.  This
allows you to update the field that has the filter to
control which subscriber receives the record.

Quote:>-----Original Message-----
>Hi everybody.

>I am trying to replicate two databases that are on the

same server (this is

Quote:>a test). I use merge replication in MS SQL Server 7.0. I
have created a
>dynamic filter for the publication. This filter is based
on the subscriber
>username. The subscription I use is a Pull subscription.

>The table I publish contains 3 columns : a global unique
id, a user name,
>and a text column.

>I can add and insert rows in the publisher database and
the changes appear
>at the subscriber (if the added or updated rows contain
the subscriber's
>username). I can also add or update rows at the subcriber
and the
>modifications are updated at the publisher.

>Now is the PROBLEM (or question).

>Is it normal that ALL the rows that I add at the

subscriber appear at the

Quote:>publisher (even the ones that DO NOT contain the username
used in the merge)
>?

>Also, is it normal that the rows added at the subscriber
that do not contain
>the username used in the filter are deleted at the
subscriber?

>I can't find these answers anywhere...

>Thank you in advance for giving me the answers to my
questions.

>Hugues

>.