22,206
社区成员
发帖
与我相关
我的任务
分享
SELECT [id]
,[centerno]
,[centername]
,[wireip]
,[wireport]
,[wireusing]
,[wirelessip]
,[wirelessport]
,[wirelessusing]
,[pri]
,[centertype]
,[setsendport]
,[wiresendport1]
,[wiresendport2]
,[wirelesssendport1]
,[wirelesssendport2]
FROM [10.32.225.24].[DB_DBIAdapter].[dbo].[t_center_def]
-- 删除/重建链接服务器
use master
if exists(select 1 from sys.servers where name='10.32.225.24')
begin
exec sp_dropserver '10.32.225.24','droplogins' -- 删除链接服务器
end
-- 创建链接服务器
exec sp_addlinkedserver '10.32.225.24','','SQLOLEDB','10.32.225.24'
exec sp_addlinkedsrvlogin '10.32.225.24','false',null,'[账号]','[密码]'
exec sp_serveroption '10.32.225.24','data access','true'
-- 测试
select *
from [10.32.225.24].[DB_DBIAdapter].[dbo].[t_center_def]