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.
- Configuring Linked server
- Security settings
- Setting server options
- Linked Server content
- Viewing DDL definition
To create, edit and drop linked servers, you can also use the context menu and the Navigation bar of Linked servers manager.