http://www.microsoft.com/downloads/details.aspx?FamilyID=58A7C46E-A599-4FCB-9AB4-A4334146B6BA&displaylang=en

Tablediff is a really handy tool which can be used to fix data sync issues.  It is located in the 90\COM directory.  If you are ever in a situation whereby replica databases are out of sync then tablediff can save your life.  It will compare two tables and generate and output, which includes the T-SQL to fix the data, really handy for avoiding a re-initialisation of the data.

Take a look at the info here: http://msdn.microsoft.com/en-us/library/ms162843.aspx

It’s also listed as one of the top 10 hidden gems in SQL Server 2005 http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx