A nice way of finding difference between tables is the TABLEDIFF command.

Well, TABLEDIFF is primarily replicating tables but we can also utilize in comparing tables.

To get a detailed help on TABLEDIFF, type

C:\Program Files\Microsoft SQL Server\90\COM>TABLEDIFF /?

Keep in mind that in order to see the difference the source and destination tables must be identical.