How to Add Linked server with a different name

In this post, I will walk you through the process of creating a linked server with a custom name.

EXEC master.dbo.sp_addlinkedserver @server = N'STUDENTINFO'
, @srvproduct = N'SQL Server'


EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'STUDENTINFO'
, @useself = N'False'
, @locallogin = NULL
, @rmtuser = N'ReadLogin'
, @rmtpassword = 'hJa1b3v&*7NB5q98j76('
GO

For additional reference, check the following articles:

DB2 as a Linked Server

Oracle as a Linked Server