Create Linked Server in SQL Server

Create Linked Server SQL Server

link to any server belongs to SQL Server group and can be accessed the database of that server using the linked server. Creation of linked server script below

USE [master]
EXEC master.dbo.sp_addlinkedserver @server = N’LinedServerName’, @srvproduct=N”, @provider=N’SQLNCLI’, @datasrc=N’ServerName’ -> The Target server

Also you can create via SSMS.

Server -> Server Objects -> Linked Server -> Right Click – > New Linked Server.

Create Linked Server in SQL Server was last modified: October 1st, 2017 by Justin Antony

About Justin Antony

Leave a Reply