Compare records of two tables?

Hi

I am trying for compare two tables records and if which records are not match insert in to both table and at end both table records will be same.

using stored procedure & I need also pass server name database name.

thanks

I did not know how to use store procedures but i did use TableDiff.exe to compare both tables.

Here is the link:

http://www.replicationanswers.com/TableDiff2005.asp

Have a nice day

|||

Check out SQL Data Compare from RedGate.

Martin