Configuring Ad Hoc Distributed Queries:
exec sp_configure 'show advanced options',
1
RECONFIGURE;
exec sp_configure 'Ad Hoc Distributed Queries',
1
RECONFIGURE;
Output:
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'Ad Hoc Distributed Queries' changed from 1 to 1. Run the RECONFIGURE statement to install.