Thanks for your response. Below are the statements I am running

On Instance1, it is something similar to the below statement:

SELECT A.COL1, B.COL2,C.COL3, A.COL4, B.COL5, C.COL6 FROM

ABC A JOIN DEF B...

Thanks a lot.

It working.

Regards,

Thank you very much.

Let me try and update.

Regards,

Thanks Durai,

I have made the changes and will monitor on Monday and update you on the same.

Regards,

Got it. Thank you very much for your help.

Thank you very much for your help. As per your advice, I turned ON profiler for Audit Login Failed. The application name is Report Server on the same box. I...

Thank you very much. I'll try to investiage and will keep you posted.

Thanks Andy. Appreciate your help.

Others,

Request you to advice if you have any inputs on this.

Good Question. This is required as there will be changes made to the columns at Source (adding or dropping columns). If we go with SSIS, we need to do mapping...

Thank you very much. That's what I am looking for.

Thanks Gail and Lowell for your help. Let me try using both of your logic / code.

Pawana Paul

Thanks for the script. This script is for comparision of database objects with 2 databases on same instance and database names are coded. Is it possible to use MSforeachDB stored...

Yes. Only trying to see what objects are on one instance and not the other. That is what is my requirement. Please let me know if you have better option...

Thank You Gila,

I am trying to workaround in TSQL using linked server as getting SQLCompare at this point will be difficult and I can't wait for long. The logic I...

Thank for your response.

I am looking at SQL Script with the combination of Linked Server.

I am not familiar with Redgate and there will be licencing issue to use in my...