Here I am trying to how to create linked server with different 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
Other References: