MSSQL: Enable ad hoc distributed queries using sp_configure.

Posted March 27th, 2013


Allows Ad Hoc Distributed Queries using by executing sp_configure.

EXEC sp_configure 'show advanced options', 1
RECONFIGURE

EXEC sp_configure 'Ad Hoc Distributed Queries', 1
RECONFIGURE