Freigeben über


Configuration.AdHocDistributedQueriesEnabled-Eigenschaft

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)

Syntax

'Declaration
Public ReadOnly Property AdHocDistributedQueriesEnabled As ConfigProperty 
    Get
'Usage
Dim instance As Configuration 
Dim value As ConfigProperty 

value = instance.AdHocDistributedQueriesEnabled
public ConfigProperty AdHocDistributedQueriesEnabled { get; }
public:
property ConfigProperty^ AdHocDistributedQueriesEnabled {
    ConfigProperty^ get ();
}
member AdHocDistributedQueriesEnabled : ConfigProperty
function get AdHocDistributedQueriesEnabled () : ConfigProperty

Eigenschaftswert

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

Hinweise

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.

Beispiele

Konfigurieren von SQL Server in SMO

Siehe auch

Verweis

Configuration Klasse

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

Serverkonfigurationsoptionen

sp_configure (Transact-SQL)