Results 1 to 1 of 1
  1. #1
    Join Date
    May 2006
    Posts
    1

    Unanswered: Merge replication- update to filter table times out

    I have a merge replication setup in MSSQL 2005. It has one main table which is filtered by host_name and a number of other tables are joined to this filtered table using a merge filters (ID of the main table is FK to the joined tables). The replication works and changes are propogated in both directions from the publisher to the subscriber and vice-versa.

    However, an update to the main table itself fails (times out) both in code and the SQL Mgmt Console. If the publication is dropped the update goes through without a problem.

    I suspect the merge article triggers are trying to change the snapshot even as the update is taking place and hence the update times out. If there was a way to defer the updating of the snapshot, there might be a solution.

    Any help would be greatly appreciated.

    Thanks

    Reggie
    Last edited by reggie61; 05-31-06 at 17:32.

Posting Permissions

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