ADD Linked Server in SQL

ADD Linked Server in SQL

sp_addlinkedserver [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ] 
     [ , [ @provider= ] 'provider_name' ]
     [ , [ @datasrc= ] 'data_source' ] 
     [ , [ @location= ] 'location' ] 
     [ , [ @provstr= ] 'provider_string' ] 
     [ , [ @catalog= ] 'catalog' ] 

For more information 

https://msdn.microsoft.com/en-us/library/ms190479.aspx 

Example:

sp_addlinkedserver  @server=  'LINK_Database',  @srvproduct='' 
     , @provider=  'SQLNCLI'
    , @datasrc=  'server ip' 

--------------------------------------------------

Get list of Linked Server in SQL

SELECT * FROM sys.Servers