Post
Ask Question

Creating Linked Server in SQL

Creating Linked Server:
  1. EXEC sp_addlinkedserver     
  2.    @server=N'IIC82',   
  3.    @srvproduct=N'',  
  4.    @provider=N'SQLNCLI',   
  5.    @datasrc=N'IIC82\SQL2008R2';  
Here you need to replace with your server name.