Merge Replication, Delete is working at publisher(if a row is deleted at publisher it's getting updated at subscriber) and not working at subscriber(if a row is deleted at subscriber it's not getting deleted at publisher)?
Hi, We've merge replication configured in our environment(Between 4 SQL servers 2008R2). As we know merge replication is bidirectional, its working fine in case of inserts i.e, if a row is inserted at publisher it's getting updated at subscriber and vice-versa. The Issue is, if row gets deleted at publisher its getting deleted at subscriber but, if a row gets deleted in any of 3 subscribers its not getting deleted at publisher. I've checked delete_tracking option in sp_helpmergearticle and its set to '1'. Please help me out. Thank you in advance. Regards, Nadeem