Online Documentation for SQL Manager for SQL server

Linked servers manager

The Linked servers manager allows you to browse the list of linked servers and manage them efficiently.

To launch the tool, select the Services | Linked Servers main menu item, or right-click the host alias in the DB Explorer tree and select the Tasks | Linked Servers item from the context menu.

The list displays the existing linked servers as a grid with the following columns: Server Name, SQL Server, Provider, Data Source, Location, Provider String, Catalog.

Click a column caption to sort items by values of this column in the ascending or the descending mode.

Right-click an item within the list to call the context menu allowing you to create a new linked server and specify its properties using Linked Server Editor, edit, delete the selected linked server, retrieve its content, refresh the list, or show/hide columns of the list. Using the context menu you can also export the list of linked servers to any of supported output file formats.

Linked servers management tools are also available through the Navigation bar of the Linked servers manager.

To display the actual linked server contents, press the Show Contents button.

Hint: Linked server contents are also available within the Content tab of Linked Server Editor.