Enable Ad Hoc Distributed Queries using sp_configure


/ Published in: SQL
Save to your folder(s)

Allows Ad Hoc Distributed Queries using by executing sp_configure.


Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.