REM The tablediff.exe file is typically located in c:\Program Files\Microsoft SQL Server\90\COM

tablediff -sourceserver MyServer -sourcedatabase MyDatabase -sourcetable MyTable1 -destinationserver MyServer2 -destinationdatabase MyDatabase2 -destinationtable MyTable2 -o diff_output.txt -F diff_script

http://msdn.microsoft.com/en-us/library/ms162843.aspx

The TableDiff utility comes with SQL Server 2005 and can report differences on schema and data. The most popular feature of TableDiff is the fact that it can generate a script that you can run on the destination that will reconcile differences between the tables.

Original source was a TechNet article called [Top 10 Hidden Gems In SQL Server 2005][1].

[1]: http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/gems-top-10.mspx "Top 10 Hidden Gems in SQL Server 2005"

SQL Server Find Differences Between Two Tables

DOS Batch