Ad Hoc Distributed Queries组件
启用Ad Hoc Distributed Queries:
exec sp_configure 'show advanced
options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed
Queries',1
reconfigure
使用完成后,关闭Ad Hoc Distributed Queries:
exec
sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure
'show advanced options',0
reconfigure