当前位置:操作系统 > Unix/Linux >>

使用sp_configure启用'Ad Hoc Distributed Queries'解决

使用sp_configure启用'Ad Hoc Distributed Queries'解决
 
 1.启用Ad Hoc Distributed Queries:
 
exec sp_configure 'show advanced options',1
reconfigure
exec sp_configure 'Ad Hoc Distributed Queries',1
reconfigure

 

 
2.为了安全使用完成后,关闭Ad Hoc Distributed Queries:
 
exec sp_configure 'Ad Hoc Distributed Queries',0
reconfigure
exec sp_configure 'show advanced options',0
reconfigure

 


CopyRight © 2022 站长资源库 编程知识问答 zzzyk.com All Rights Reserved
部分文章来自网络,