sql server replication: Several join filters on the same table -- sql server replication

Several join filters on the same table

Emmanuel Borey
8/6/2003 10:21:30 PM

sql server replication:

Hi All,

I'm trying to filter a table that is a join between two other tables
(filtered too) . For example:

a table A, filtered on the value of a specific column (A.col1='x')
a table B, filtered on the value of a specific column (B.col2='y')
a table C, with a FK on A and a FK on B, filtered by a join filter on A and
another on B

But it is not working and the replication failed. The table A and B are OK
and contain only the filtered rows but C contains rows that do not meet the
join filter clauses and raised an integrity violation (the foreign key
cannot be created).

Does anybody encounter the same problem?
Is there any limitation on the number of join filter on a given table?

Thanks for any fast responses,
Emmanuel

Re: Several join filters on the same table

johnston NO[at]SPAM mounet.com
8/7/2003 10:33:26 AM

My recommendation is to come up with only one mapping table (Table A).
Filter on a specific value. Then use that mapping table in the join
filters for Table B and Table C. It might be that you will have to
create a new Table A call it Table X, then write join filters for all
three tables. That was my solution to an identical problem which I
had.

V/R Jim Johnston
MCSD, MCDBA

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.