Proprietà Configuration.AdHocDistributedQueriesEnabled

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

Spazio dei nomi  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Sintassi

'Dichiarazione
Public ReadOnly Property AdHocDistributedQueriesEnabled As ConfigProperty 
    Get
'Utilizzo
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

Valore proprietà

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

Osservazioni

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.

Esempi

Configurazione di SQL Server in SMO

Vedere anche

Riferimento

Configuration Classe

Spazio dei nomi Microsoft.SqlServer.Management.Smo

Altre risorse

Opzioni di configurazione del server

sp_configure (Transact-SQL)