Comparing two tables in two different databases

I want to compare the records in a table on my live database server with the same table that is my test database server. How can I do this?

Note that both databases are mirrors of each other but contain slightly different data and are on different servers.

There a couple of tools on the market like RedGate Data Compare.

The SQL Server 2005 program directory also contains a commandline utility called tablediff.exe which does just what you want.

WesleyB

Visit my SQL Server weblog @. http://dis4ea.blogspot.com