Add a server link : sp_addlinkedserver « System Functions « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. System Functions
3. sp_addlinkedserver

sp_addlinkedserver [@server =] '<server>'
    [, [@srvproduct =] '<product name>']
    [, [@provider =] '<provider name>']
    [, [@datasrc =] '<data source path>']
    [, [@location =] '<location>']
    [, [@provstr =] '<connection string>']
    [, [@catalog =] '<database or equivalent for datasource>']

EXEC sp_addlinkedserver @Server = 'MyLocalServer',
      @srvproduct = 'SQLServer OLEDB Provider',
      @provider = 'SQLOLEDB',
      @datasrc  = 'SOCRATES'

   SELECT CustomerID, CompanyName
   FROM MyLocalServer.Northwind.dbo.Customers
   WHERE CustomerID < '1'