Horizontal Filtering

[Joseph]

This should be easy!

I'm setting up transactional replication. Say that I set up a
horizontal filter such as: mytable.CurrentInfo=1. After the
snapshot's been applied, and everyone's happy, the following happens
at the publisher:

For a given replication row, mytable.CurrentInfo is updated from 1 to
0
A new row is inserted into the table, with mytable.CurrentInfo = 1.

The second item's not hard: I would expect it to meet the criteria,
and make its way down to my subscriber.

However, the first item has me puzzled. Does it get deleted from the
subscriber now that it is zero, or does it languish there?

Thanks!

-Joseph

[Joseph]

For future reference, I tested this out myself before anyone was able
to respond here...

The original row (the one that went from CurrentInfo=1 to
CurrentInfo=0) is removed from the subscriber's database, and the new
row takes its place. Just what I wanted!

This forum's activity has really dropped off over the last two
years....Where did everybody go?

-J

[Paul Ibison]

Thanks for posting the update Joseph. As an additional note, to do the same
in merge would also cause all the child records to be reparented, which can
be tremendously useful.

To answer your other question, I think more people use the forums now than
the newsgroups. Even so, the overall presence is far lower than it used to
be - I suppose blogs and websites have largely taken over. Many questions
have been answered and Googling the answer is now quicker than posting a
question!

Cheers,
Paul

[Joseph]

Thanks, Paul...You are the Master!

-Joseph

On Apr 19, 2:07 pm, "Paul Ibison" <Paul.Ibi...@ReplicationAnswers.Com.