MS SQL Server

Link Server Creation using the Preferred Name

Link Server

Objective:

Link Server creation in any preferred name like MyTelecomLink, can be done via the below script.

Here @server is the preferred name in the below script

And @datasrc is the SQL Server Instance Name along with port number if any.

The below script is tested on SQL Server 2016.

 

Leave a Reply

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