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 - 2005-03-25 : 07:08:43
|
| Atul Sood writes "Hi,We've setup some dynamic filters on our publication and we're having lots of problems. We've setup a filter on a main table and from that table we're extending the filters to some other tables. What I'd like to know how does sql server apply the filters while replicating the data to subscribers ?? In What sequence it applies those filters ??? I have a Table called 'AccountAssignment' PK - AccountAssignment_Guid, FK - Account_GuidI have some more tables .. 'Account' - PK - Account_Guid'AccountActivity' - PK - AccountActivity_Guid, FK - Account_Guid'AccountContact' - PK - AccountContact_Guid, FK - Account_Guid'AccountProductUse' - PK - AccountProductUse_Guid, FK - Account_Guid Now the main filtered table is AccountAssignment and then we're extending the filter to Account based on the relationship of Account_Guid in both tables. Afterwards, AccountActivity, AccountContact and AccountProductUse are filtered based on Account.AccountAssignment is nothing but a combination of a user with a Account. So many users can have many accounts and this relationship can be changed. For example new/existing users can be assigned new/existing accounts. They can be deleted. The problem is .. when we're assigning some accounts to a user, the records are inserted in AccountAssignment. And the next time that user synchronizes, he should get the AccountAssignments that are done for him, and based on the filters, he should also get those accounts and the relative information of that account (Activities, Contacts etc .. ) but its not happening. User is getting the AccountAssignment, but nothing else. He does not get any Account and thus no Activities, Contacts etc ... Any idea what is going on. Any help will be appreciated." |
|
|
|
|
|
|
|
Replication Filters ..