Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Surface Area Configuration for Features (Ad Hoc Data Mining Queries) - Analysis Services

SQL Server 2005

The Data Mining Extensions (DMX) OPENROWSET function supports ad hoc queries using external providers. If your applications and scripts do not use this function, disable ad hoc data mining queries.

If you enable ad hoc data-mining queries, you can enable or disable the passing of OLEDB provider name and connection string when using OPENROWSET.

Enable Ad hoc data mining queries

If checked, the DMX OPENROWSET function is enabled.

For more information, see OPENROWSET (DMX) in Microsoft SQL Server Books Online.

For more information about configuring server options, see sp_configure (Transact-SQL) in SQL Server Books Online.

Community Additions

© 2015 Microsoft