Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004
    Rhode Island

    Unanswered: Filter dost not work in merge replication

    Hello everyone,
    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.

    Last edited by smasanam; 01-21-05 at 15:55.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts