Online Documentation for SQL Manager for SQL server

Linked Servers

A Linked server is a virtual server that can be defined to SQL Server 2005 (and higher) with all the information required to access an OLE DB data source. A Linked server configuration enables SQL Server to execute commands against OLE DB data sources on remote servers. Linked servers provide a number of features: remote server access; the ability to issue distributed queries, updates, commands and transactions on heterogeneous data sources; the ability to address diverse data sources universally.



Linked Server Editor allows you to define linked server properties. It opens automatically when you create a new linked server and is available on editing an existing one.


To open a linked server in Linked Server Editor, double-click it in the DB Explorer tree or in the Linked servers manager. Alternatively, you can right-click the linked server alias and select the Edit Linked Server context menu item.



To create, edit and drop linked servers, you can also use the context menu and the Navigation bar of Linked servers manager.