Answers

If it's two different sql servers, then first you have to link them. After the linked servers are setup, you just have to prefix your tables names with server name, database name, table owner name in your SELECT queries. The following example links SERVER_01
to SERVER_02. Execute the following commands in SERVER_02:

If it's two different sql servers, then first you have to link them. After the linked servers are setup, you just have to prefix your tables names with server name, database name, table owner name in your SELECT queries. The following example links SERVER_01
to SERVER_02. Execute the following commands in SERVER_02: