References to linked server objects

You can query data in a linked server by referencing the linked server. You can reference linked server objects in distributed queries by including a fully qualified, four-part table name for each data source to query. This four-part table name should be in the following form: Server_Name.Catalog.Schema.Object_Name.

Example of four-part table name reference

The following example is a simple query that returns all information about every element in the database specified when you created the linked server.

SELECT * from LINKED_SERVER.Master.Element.Element