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 @ 2013-09-27 18:23  程序猿网友666  阅读(168)  评论(0)  编辑  收藏  举报