在数据库里执行以下脚本:

启用:

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

关闭:


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

posted on 2016-12-14 16:34  龙族少年  阅读(215)  评论(0编辑  收藏  举报