|
Posted on
2009-11-22 11:42
X龙
阅读( 263)
评论()
编辑
收藏
举报
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedBlock.gif) Code --删除链接服务器 if exists(select * from master.dbo.sysservers where isremote=0 and srvname='WIN') exec sp_dropserver 'WIN','droplogins'
--创建连接服务器 exec sp_addlinkedserver 'WIN','','SQLOLEDB','192.168.1.138' exec sp_addlinkedsrvlogin 'WIN','false',null,'aa','aa'
|