--跨库查询
select * from OPENDATASOURCE(
'SQLOLEDB',
'Data Source=fhm1;User ID=sa;Password=111111'
).herpeisfzsy.dbo.peispatient
--Ad Hoc Distributed Queries组件被禁用了,解决:
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure