Export (0) Print
Expand All
Expand Minimize

Configuration.AdHocDistributedQueriesEnabled Property

Gets the ConfigProperty object that is used to set the ad hoc distributed queries configuration option.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public ConfigProperty AdHocDistributedQueriesEnabled { get; }

Property Value

Type: Microsoft.SqlServer.Management.Smo.ConfigProperty
A ConfigProperty object that specifies the settings for the ad hoc distributed queries configuration option.

The AdHocDistributedQueriesEnabled property sets the ad hoc distributed queries configuration option. This property is used to allow ad hoc access through the OPENROWSET and OPENDATASOURCE functions on an OLE DB provider.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft