SQL Server : How to create linked server

Create linked server : sp_addlinkedserver

sp_addlinkedserver ( Stored Procedure ) is used to created linked servers in SQL server

Syntax :

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

     [ , [ @catalog= ] 'catalog' ]  

If SQL Server, provider_name, data_source, location, provider_string, and catalog do not have to be specified.