Here's a slick procedure that someone wrote for comparing two tables, pretty handy! If you don't want to fire up your favorite SQL compare tool or table diff utility, use this script to find the differences in data that you are looking for. He goes ahead and wraps a generic version in a proc so that it excludes columns that can't be compared, such as a blob. This is a keeper to bookmark because many times I'm out at a client location and can't simply download RedGate or whatever to do a comparison, or I don't have VS installed. Not bad, go check it out. Very cool!
Lee
---------------------------
Who has been putting out their Kools on my floor?! I said who's been putting their Kools out on my floor???!!!
Comparing data between two tables in SQL Server
http://blogs.msdn.com/b/ramoji/archive/2010/07/01/how-to-compare-data-between-two-tables-in-sql-server.aspx
726a68fb-8b26-4654-a7e8-80ac67b24fd9|0|.0