Thanks a lot for your help!

Murad.

Hello Victor,

I am about the scripts you have placed to use. Do other scripts, except sp_trace... one work on SQL Server 7.0 or they need to be rewriten as well...

This way :

sp_Compare2Tables_upd 'maxdata1..invmatch','maxtest1..invmatch'

Hello ,

I created the SP you gave me and ran against those table. I got the message below:

------------------------------------

Server: Msg 245, Level 16, State 1, Line 18

Syntax error...

Thanks a lot for your reply.

Yes ,I have all that stuff on the tables and the name of fields are same as well.

The only difference is that some fields have...

Thanks for your reply.

I have that script already, bu the problem is that if table structures are different then the script does not compare the data by saying that 'table...

Thanks for your reply.

What if I do not know the exact column to compare and I would like to compare whole column in tables ?

Thanks,

Murad