exec sp_addlinkedserver @server= 'SQL2', @srvproduct= '', @provider='SQLNCLI', @datasrc = '18.8.XX.X' ; --登录链接服务器
exec sp_addlinkedsrvlogin @rmtsrvname = 'SQL2', @useself = 'false ', @locallogin = null, @rmtuser ='XXXi', @rmtpassword = 'XXXXXXX';
SELECT * FROM SQL2.XXXXX.dbo.XXX ;
----在项目中已经实践过!