添加可在查询语句中远程连接的服务器

exec sp_addlinkedserver '66','','sqloledb','192.168.0.66\sqlexpress',null,null,'resourcedb'
exec sp_addlinkedsrvlogin '66','false',null,'sa',''
exec sp_helpdb
 
exec sp_addlinkedserver '66','','sqloledb','192.168.0.66\sqlexpress',null,null,'resourcedb'
exec sp_addlinkedsrvlogin '66','false',null,'sa',''
exec sp_droplinkedsrvlogin '66',null
exec sp_dropserver '66'
exec sp_helplinkedsrvlogin
exec sp_helpserver
原文地址:https://www.cnblogs.com/langu/p/2980968.html