Type: Advanced Option
SQL Server does not allow ad hoc distributed queries using
OPENDATASOURCE against providers other than the SQL Native Client OLE DB provider. When the
ad hoc distributed queries option is set to
0, SQL Server allows ad hoc access against other providers. When it is set to
1, SQL Server does not allow any ad hoc access.
Ad hoc distributed queries use the
OPENDATASOURCE functions to connect to remote data sources using OLE DB.
OPENDATASOURCE should be used only to reference OLE DB data sources that are accessed infrequently. For any data sources that will be accessed more than a few times, you should define a linked server. Enabling the ...