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.