Unanswered: Filter dost not work in merge replication
Can any one please help me out how to fix the following? I would greatly appreciate it.
The filter in my merge replication does not work.
I have create the mege replication using T-SQL not from enterprise manager.
by specifiying the following filter clause.
@subset_filterclause = N'UPDATE_DATE > CURRENT_TIMESTAMP - 30'
SQL Server synchronizes the data how ever it does not deletes the records from the subscriber which is 30 days or older.
Other details in the environments
Subscriber is MS Access database with MDAC 2.8 installed on both server and PC
Server does not have SQL Service pack 1 installed.
O/S is Windows 2000 with service pack 4 installed.