Thanks Lowry

To make u more aware of the problem below are the point :

1. I cannot copy the database to test as its huge ..probably 100 gb or so .....

Thank you guys .. I simply used

use databasename

select name from sys.tables

order by name

and got the table names... compared in excel and got the difference..

I found out that there...

Hi All,

Actually I have got a task to match all the tables of 2 servers (QA and PROD) and add tables to which

ever database doesn't have one or is missing......