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

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

 

posted @ 2013-03-25 16:15  二师弟tl  阅读(137)  评论(0)  编辑  收藏  举报