How do I query a server in SSMS?

In SSMS open Registered Servers and create a New Server Group under Local Server Groups. Under this group create New Server Registration for each server you wish to query. If the DB names are different ensure to set a default for each in the properties. Now go back to the Group you created in the first step, right click and select New Query.
For More Information Please Refer:
https://stackoverflow.com/questions/1144051/selecting-data-from-two-different-servers-in-sql-server
You May Also Like to Read: