• Sachin Nandanwar (6/20/2014)


    The deadlocks now typically involve inserts and deletes from the filter table and CRUD action against a table that has a foreign key to master table. The deadlocks are keylocks that the filter table creates.

    Is dropping the master-child relationship as option ?

    No. that is not where the deadlock is coming from. The deadlock comes between merge replication's filtered queries and user's transactions on that same filter table.