sql

Linked server alias

Claire Furney

Add a linked server using a different name or add a reference to the local server using a different name (handy if importing databases which used to be on different servers, but temporarily on the same server).

sp_addlinkedserver 'Alias', '', 'SQLOLEDB', 'ServerName'