Creating Linked Server in SQL

Sibeesh Venu

12y1.2kCode

This program show how to create Linked Server.

Creating Linked Server:

EXEC sp_addlinkedserver
   @server=N'IIC82',
   @srvproduct=N'',
   @provider=N'SQLNCLI',
   @datasrc=N'IIC82\SQL2008R2';

Here you need to replace with your server name.