-
Notifications
You must be signed in to change notification settings - Fork 32
Ad Hoc Distributed Queries
MichelleTaylorRG edited this page Jun 19, 2019
·
5 revisions
If you use OPENROWSET and OPENDATASOURCE to access data you need to enable Ad Hoc Distributed Queries. By default it is disabled. To enable Ad Hoc Distributed Queries run the following:
sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE
GO
sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE
GO