链接远程服务器 sp_addlinkedserver

EXEC sys.sp_droplinkedsrvlogin 'db27' ,Null
EXEC sys.sp_dropserver @server='db27'

exec sp_addlinkedserver
@server ='db27'
,@provider ='SQLOLEDB'
,@datasrc ='10.165.12.27'
,@srvproduct='MS'

EXEC sp_addlinkedsrvlogin
'db27'
,'false'
,NULL
,'sa'
,'sa123456!'

select * from [db27].wms.dbo.workday