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.
Thursday 22 August 2013
Configuring Ad Hoc Distributed Queries in SQL SEREVER
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment