sql2005 OPENDATASOURCE 需要Ad Hoc Distributed Quer

exec sp_configure 'show advanced options',1
 reconfigure
 exec sp_configure 'Ad Hoc Distributed Queries',1
 reconfigure
 GO

 SELECT *
 FROM OPENDATASOURCE('SQLOLEDB', 'Data Source=192.168.1.100,1433;User ID=sa;Password=sa').msdb.dbo.backupfile


 exec sp_configure 'Ad Hoc Distributed Queries',0
 reconfigure
 exec sp_configure 'show advanced options',0
 reconfigure