Configuration.AdHocDistributedQueriesEnabled 属性

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

命名空间:  Microsoft.SqlServer.Management.Smo
程序集:  Microsoft.SqlServer.Smo(在 Microsoft.SqlServer.Smo.dll 中)

语法

声明
Public ReadOnly Property AdHocDistributedQueriesEnabled As ConfigProperty 
    Get
用法
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

属性值

类型: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.

示例

在 SMO 中配置 SQL Server

请参阅

参考

Configuration 类

Microsoft.SqlServer.Management.Smo 命名空间

其他资源

服务器配置选项

sp_configure (Transact-SQL)