We have two databases on different servers (2008 and 2005). Each has a publication and subscription. One publishes 3 tables to the other, and the other publishes 6 tables to the other. The replication monitor says both publications are running. The performance is excellent on both and the latency is 00:00:02 on one and 00:00:04 on the other.
All tables have the same number of rows across databases, but some of the values in the columns are different. I ran a query comparing TableA.col1 to TableB.col3 on one server and it returns zero rows. On the other server, the same query against the same tables returns 15 rows. TableA is published from one server and TableB is published from the other server.
What would cause this and how should I correct it? Is there something I can do that can alert me to this?