Linked server in Ms SQL

Run below queries to add linked server

EXEC master.dbo.sp_addlinkedserver
@server = 'ServerName',
@provider = 'ProviderName',
@datasrc = 'DataSource',
@srvproduct=''
Example::
EXEC master.dbo.sp_addlinkedserver
@server = 'A-2011',
@provider = 'MSDASQL',
@datasrc = 'SERVER=A-2011;UID=sa;PWD=sa;',
@srvproduct=''
-----------------------------------------
EXEC master.dbo.sp_addlinkedsrvlogin
@rmtsrvname='ServerName',
@useself='False',
@locallogin=NULL,
@rmtuser='UserName',
@rmtpassword='Password'
Example::
EXEC master.dbo.sp_addlinkedsrvlogin
@rmtsrvname='A-2011',
@useself='False',
@locallogin=NULL,
@rmtuser='sa',
@rmtpassword='sa'


sp_addlinkedserver is used to create a linked server.
sp_addlinkedsrvlogin is used to create login on the linked server.