SQL Server/T-SQL Tutorial/System Functions/sp addlinkedserver

Add a server link

   <source lang="sql">

sp_addlinkedserver [@server =] "<server>"

   [, [@srvproduct =] "<product name>"]
   [, [@provider =] "<provider name>"]
   [, [@datasrc =] ""]
   [, [@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"</source>