sp_configure ‘show advanced options’, 1; RECONFIGURE;
sp_configure ‘Ad Hoc Distributed Queries’, 1; RECONFIGURE;
ad hoc opens security issues – use very carefully!!
only supposed to use ad hoc if there is infrequent access to the data
for any data sources that will be accessed more than several times, define a linked server.