How to Add Linked server with a different name

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:

Spread the love

Leave a Comment