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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-14 : 11:00:00
|
| Natrio writes "Hi,I try to setup a filtered merge replication based on the branch id, but when I try to use 'generate filters automatically' in the replication wizard and click next, an error shows up:--error msg--SQL Server Enterprise Manager could not extend the filter to other tables based on defined relationshipError 208: Invalid object name 'PARTNER_ADDRESS'.invalid object name 'PARTNER'.A column used in filter clause '[PARTNER_ADDRESS].[PAR_ID]=[PARTNER].[PAR_ID] and [PARTNER_ADDRESS].[BRC_ID] =[PARTNER].[BRC_ID]' either does not exist in the table 'PARTNER_ADDRESS' or cannot be excluded from the current partition.--error msg--The PARTNER and PARTNER_ADDRESS do contain those columns.When I tried to use other tables, the same error also occured.When I use full merge replication, everything went smooth (does not include relationship).Do you know what is wrong or how to setup filtered merge replication correctly?" |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-02-14 : 14:05:54
|
| Duplicate Post. See answers at: [url]http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=12917[/url]------------------------GENERAL-ly speaking... |
 |
|
|
|
|
|
Setting up filter in merge replication