compare all the records of all the fields of two tables

Does some exist it sorts things out of to compare all the records of all the
fields of two tables and to see that this different one among the tables?
Each table has 90 fields
example
table 1 table 2 table1
table2
field1=a field1 = b field2=5 field2=6
field1=u field1=k field2=9 field2=8
field2=10
field2=50Red Gate has a very popular tool to do this..(if you don;t wish to write
your own).
You may also find a script on www.sqlservercentral.com
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:O8KD8ogjDHA.2232@.TK2MSFTNGP09.phx.gbl...
> Does some exist it sorts things out of to compare all the records of all
the
> fields of two tables and to see that this different one among the tables?
> Each table has 90 fields
>
> example
> table 1 table 2 table1
> table2
> field1=a field1 = b field2=5
field2=6
> field1=u field1=k field2=9
field2=8
> field2=10
> field2=50
>
>
>