FilterRows

Hi, I posted this a while back but had no response. I wonder if anyone can
help.
I am using transactional replication.
CREATE TABLE T1 (LogID INT, Quantity INT)
Table T1 is an article to be published. I only want to publish rows that
have a quantity > 5. The initial snapshot filters replicates all rows that
meet the criteria.
However, when a quantity changes to above 5, ie becomes eligible to be
replicated, this row is not replicated at the subscriber.
Publisher
Table T1 all rows with Quantities 0 - 10
Subscriber
Table T1 only rows with Quantities 5 - 10
I run the following update at the publisher
UPDATE T1
SET Quantity = 6
WHERE Quantity = 4
These rows do not get replicated.
Am i right in thinking this is by design and that it takes the exact DML
statement from the publisher and runs it on the subsciber?
Does anyone have a workaround for this or do i have to replicate the entire
table?
Thanks again
Rich
I just set this up and rows the were < than 5 and changed to be greater than
5 were replicated...
"Rich" wrote:

> Hi, I posted this a while back but had no response. I wonder if anyone can
> help.
> I am using transactional replication.
> CREATE TABLE T1 (LogID INT, Quantity INT)
> Table T1 is an article to be published. I only want to publish rows that
> have a quantity > 5. The initial snapshot filters replicates all rows that
> meet the criteria.
> However, when a quantity changes to above 5, ie becomes eligible to be
> replicated, this row is not replicated at the subscriber.
> Publisher
> Table T1 all rows with Quantities 0 - 10
> Subscriber
> Table T1 only rows with Quantities 5 - 10
> I run the following update at the publisher
> UPDATE T1
> SET Quantity = 6
> WHERE Quantity = 4
> These rows do not get replicated.
> Am i right in thinking this is by design and that it takes the exact DML
> statement from the publisher and runs it on the subsciber?
> Does anyone have a workaround for this or do i have to replicate the entire
> table?
> Thanks again
> Rich
>
>
|||I've tried again and this time its worked. Thanks!
"Jeffrey K. Ericson" <JeffreyKEricson@.discussions.microsoft.com> wrote in
message news:DB145F6B-5C28-48F1-B714-2EED6C02F8E7@.microsoft.com...[vbcol=seagreen]
>I just set this up and rows the were < than 5 and changed to be greater
>than
> 5 were replicated...
> "Rich" wrote: