Creating Linked Server in SQL

Creating Linked Server:
[sql]
EXEC sp_addlinkedserver
@server=N’IIC82′,
@srvproduct=N”,
@provider=N’SQLNCLI’,
@datasrc=N’IIC82\SQL2008R2′;
[/sql]
Here you need to replace with your server name.