Posted - 08/30/2013 : 21:35:54
I got a issue in Merge Replication, Delete is working at publisher(if a row is deleted at publisher then its getting deleted at subscriber) and not working at subscriber(if a row is deleted at any of three subscribers then its not getting deleted at publisher). We've three subscribers, each has the same issue.
When a row is deleted at publisher or subscriber then MSmerge_tombstone gets updated. What I've found is, When I've deleted a row at publisher then the row with corresponding rowguid got updated in MSmerge_tombstone. But in case of subscriber, the corresponding row(rowguid) is not getting updated in MSmerge_tombstone.
Does it has anything to do with merge_delete_trigger(MSmerge_del_........)? or
Does it depend on editions(Publisher edition is Enterprise 2008R2(SP1), Subscribers edition is Standard 2008R2(sp1))?
Please let me know your valuable suggestion.
Edited by - tkizer on 08/31/2013 00:54:16