Thread: MS SQL Server General Questions/How to enable the use of 'Ad Hoc Distributed Queries' by using sp_configure

    
08 February 2011

18:23:48
sergey


Posts: 0

How to enable the use of 'Ad Hoc Distributed Queries' by using sp_configure

www.kodyaz.com/articles/enable-Ad-Hoc-Distributed-Queries.aspx


 


 
    
08 February 2011

18:24:58
sergey


Posts: 0

Re: How to enable the use of 'Ad Hoc Distributed Queries' by using sp_configure

exec sp_configure 'show advanced options', 1 reconfigure


exec sp_configure


sp_configure 'Ad Hoc Distributed Queries', 1


reconfigure