sp_addlinkedserver [@server =] ''
[, [@srvproduct =] '']
[, [@provider =] '']
[, [@datasrc =] '']
[, [@location =] '']
[, [@provstr =] '']
[, [@catalog =] '']
EXEC sp_addlinkedserver @Server = 'MyLocalServer',
@srvproduct = 'SQLServer OLEDB Provider',
@provider = 'SQLOLEDB',
@datasrc = 'SOCRATES'
SELECT CustomerID, CompanyName
FROM MyLocalServer.Northwind.dbo.Customers
WHERE CustomerID < '1'