Sarabpreet,

Thank you for this straight-forward description and instructions on Tablediff.

Yes, the EXCEPT operator is easy to use to find rows that differ between tables, but then Tablediff also can give you HOW they differ, a separate question which would need a lot more coding with a TSQL script. As with most everything in IT, there are multiple ways to approach a change analysis question and it's good to understand the strengths of the various tools available.