exec sp_addlinkedserver 'ddxx', '', 'SQLOLEDB','1.192.168.220'
exec sp_addlinkedsrvlogin 'ddxx','false',null,'sa','123'
go
--查看
---EXEC sp_helpserver
--删除
--exec sp_dropserver 'ddxx','droplogins'
--go
exec sp_addlinkedserver 'ddxx', '', 'SQLOLEDB','1.192.168.220'
exec sp_addlinkedsrvlogin 'ddxx','false',null,'sa','123'
go
--查看
---EXEC sp_helpserver
--删除
--exec sp_dropserver 'ddxx','droplogins'
--go