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?
>
Monday, March 12, 2012
Row Filter not working
Labels:
database,
filter,
filterselect,
followingrow,
ltlttablegtgt,
ltpublished_columnsgt,
microsoft,
mysql,
oracle,
publication,
replication,
row,
server,
snapshot,
sql,
transactional,
working
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment