Aracılığıyla paylaş

Configuration.AdHocDistributedQueriesEnabled Property

  • Makale

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

'Bildirim
Public ReadOnly Property AdHocDistributedQueriesEnabled As ConfigProperty
    Get
'Kullanım
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

Property Value

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

Remarks

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.

Examples

Configuring SQL Server in SMO

See Also

Reference

Configuration Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Server Configuration Options

sp_configure (Transact-SQL)