jinyuttt

导航

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

posted on 2011-08-03 10:06  代码苦行僧  阅读(222)  评论(0编辑  收藏  举报