Merge Replication - Unnecessary Update

Question

Hello all,

first sorry for my english :) .

If i execute this query, i get the insert/update that will be replicated. (this query return 0 rows)
But when i execute the merge agent i see too many updates and i dont understant that. can someone explain that to me?

select EntradasDelDia.id_sesion,EntradasDelDia.id_socio,
          MSmerge_genhistory.generation,
          MSmerge_genhistory.coldate,
          MSmerge_genhistory.genstatus,
          MSmerge_genhistory.changecount
from EntradasDelDia
inner join MSmerge_contents
on EntradasDelDia.rowguid = MSmerge_contents.rowguid
inner join MSmerge_genhistory
on MSmerge_contents.generation = MSmerge_genhistory.generation
where MSmerge_genhistory.genstatus = 0

Answer 1

Your query looks for pending changes for the EntradasDelDia article.  Is it possible the updates you are seeing on synchronization are for another article?

---

Brandon Williams (blog | linkedin)

Answer 2

No Brandon it was the first thing checked :/

I have set the retention days in 14. (Default value i think)

Brandon if i put where MSmerge_genhistory.genstatus = 1.Then return 6800 rows, the same that are updated in the publisher.

genstatus = 1 (its mean close, then i dont understand :S)

-------------------------

Another question Brandon, maybe you can help me, when i run the merge agents the MSMerge_genhistory remove the rows where the retention days has come or not?

v>