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 |
|
shandyman
Starting Member
2 Posts |
 Posted - 2008-02-20 : 08:48:12
|
| Im using SQL 2005 SP2 as the publisher and SQL Mobile subscribers and Im convinced I have found a replication bug .....but maybe Im just being stupid!I have an account manager table which links to companies and users.The organisation table use a nasty @subset_filterclause filter against the account management table to decide what records to retrieve for each subscriber.This works fine and updates either way are replicated as you would expect.However when an account manager is changed and the organisation no longer fulfils the filter criteria, it is not removed from the subscriber (unless I delete the db and download it from scratch)Surely this is a bug?Just to clarify the filter clause was ok, I added the account management table to the filtered tables using the exact same @subset_filterclause.Now when I change an account manager, the account management reocrd is correctly removed from the subscriber but the organisation record remains on the subscriber? Have I missed something obvious? |
|
|
shandyman
Starting Member
2 Posts |
|
|
|
|
|
Replication Filter Bug?