Monday, March 12, 2012

Row Filter not working

I have a snapshot/transactional replication publication with the following
row filter:
SELECT <published_columns> FROM <<TABLE>> WHERE ItemName
not in ('dbsvrip','otfrconn','mapdir') and AppTypeID<>7
The snapshot generated just fine, but now none of the changes to the table
are getting replicated.
I'm using sql2000.
Any ideas?
I resolved this problem by changing the WHERE CLAUSE to:
Itemname<>'dbsvrip' and Itemname<>'otfrconn' and Itemname<>'mapdir' and
AppTypeID<>7.
"Need more Zzzz" wrote:

> I have a snapshot/transactional replication publication with the following
> row filter:
> SELECT <published_columns> FROM <<TABLE>> WHERE ItemName
> not in ('dbsvrip','otfrconn','mapdir') and AppTypeID<>7
> The snapshot generated just fine, but now none of the changes to the table
> are getting replicated.
> I'm using sql2000.
> Any ideas?
>

No comments:

Post a Comment