远程数据库配置连接本地化 

exec sp_addlinkedserver 'severxxx','','SQLOLEDB','110.00.xxx.xxx'
exec sp_addlinkedsrvlogin 'severxxx','false',null,'sa','123456'
exec sp_dropserver 'severxxx','droplogins'

 

posted @ 2019-05-15 14:53  取经路上  阅读(266)  评论(0)  编辑  收藏  举报