CREATE VIEW V_TEST

AS

            SELECT *

                        FROM CH1.DB1.TEST1

            UNION ALL

            SELECT *

                        FROM CH2.DB2.TEST2

By using profiler, we can confirm that...

Thank you very much. This syntax is working great.

First suggestion did created connection to local server with windows authentication. Consider it a step closer to final solution, as previously that...

This statement does not make connection to remote server even when correct value is supplied for Data Source. It connects to local server. As required database does not exists on...