Linked Server In Sql Server 2005. In the connect to server dialog box, specify the name of the appropriate sql server, and then click connect. Create a linked server on the other server to the hosting server.

Execute the following statements one by one to see how the linked server works. Rhoit is right, but you may test the 'linked table' scenario: [servername/instance] use an alias when pulling from a table or view from the linked server because you can only have 4 parts in the naming convention, so, [servername/instance.