This isn’t a task I perform often but yesterday, I had to compare a table from one of the DBs w/ the actual file to try and ID the differences because I was getting alert stating: datetime field overflow. Quickest way would be to BCP out the table and then compare it using Beyond Compare.
Turns out there was a typo in the datetime field: 03/28/2208 instead of 03/28/2008.