Wednesday, June 27, 2012 12:31 PM
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?
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
- Edited by danielovik Wednesday, June 27, 2012 12:32 PM
Wednesday, June 27, 2012 6:04 PMModerator
Wednesday, June 27, 2012 6:32 PM
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>
- Edited by danielovik Wednesday, June 27, 2012 6:33 PM