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.

Leave a Reply

Your email address will not be published. Required fields are marked *

Serverless 360