Configuring Ad Hoc Distributed Queries in SQL SEREVER

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.
Ebook Download
View all
Learn
View all