What is Linked Server?
The easiest way to create a Linked Server is through Enterprise Manager.
- In the left pane, expand the objects down to the desired server, where the Linked Server will be created.
- Expand Databases of the desired server and click on the "Security" Folder
- Right Click on "Linked Servers" and select "New Linked Server". Specify all the parameters for the server to be linked to.