I have recently used Tablediff utility to troubleshoot an SQL 2008R2 replication issue where there was one row on subscriber that didn't get the update from the publisher. There was no error in replication monitor.
Although clearly there was difference, Tablediff reported that the data in subscriber and publisher are identical. I ran the utility on a 40GB table, and it finished in 30 seconds. Is there gotchas on running this utility? Why did it appear to be unreliable? I was really excited about the utility and really hope it was just me not doing it correctly. Any idea? Thanks.