Posted By

jprochazka on 03/27/13


Tagged

mssql


Versions (?)

Enable Ad Hoc Distributed Queries using sp_configure


 / Published in: SQL
 

Allows Ad Hoc Distributed Queries using by executing sp_configure.

  1. EXEC sp_configure 'show advanced options', 1
  2. RECONFIGURE
  3.  
  4. EXEC sp_configure 'Ad Hoc Distributed Queries', 1
  5. RECONFIGURE

Report this snippet  

You need to login to post a comment.