EXEC sp_addlinkedserver ‘LNKName‘, ‘‘, ‘MSDASQL‘, NULL, NULL, ‘DRIVER={SQL Server};SERVER=ServerName;UID=UserName;PWD=password;‘ GO
exec sp_addlinkedsrvlogin ‘LNKName‘,‘false‘,null,‘UserName‘, ‘password‘
原文：https://www.cnblogs.com/Hawk-Hong/p/10537306.html