Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Table owner in filtering replication

Author  Topic  natrio Starting Member 7 Posts Posted - 2002-02-18 : 01:28:39 Hi group, Is table owner property affects filtering in replication? I tried to setup filtered merge replication which db owner and table owner is foo. After I try to specify filter criteria, an error shows up, but when I change table owner to dbo, no errors occured. Here is the schema: TABLE1: PAR_ID(k), BRC_ID(k), COL1 TABLE2: PAR_ID(k), BRC_ID(k), COL2, COL3 Relation between TABLE1 and TABLE2 is foreign key constraints only.