How to create a SQL Server link server with a different name.

If select SQL linked server in the GUI you can’t specify a different name for the SQL Server.  You can only use the SQL host name as the Link Server name.   Here is an example of creating a Linked Server via script to specify link server name myGX620 for the SQL Server host name…

0