通过

OleDbProviderSettings.DisallowAdHocAccess 属性

  • 项目

Gets or sets the Boolean property value that specifies whether SQL Server allows ad hoc access to data by using OPENROWSET and OPENDATASOURCE functions with the OLE DB provider.

命名空间：  Microsoft.SqlServer.Management.Smo
程序集：  Microsoft.SqlServer.Smo（在 Microsoft.SqlServer.Smo.dll 中）

语法

声明
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property DisallowAdHocAccess As Boolean 
    Get 
    Set
用法
Dim instance As OleDbProviderSettings 
Dim value As Boolean 

value = instance.DisallowAdHocAccess

instance.DisallowAdHocAccess = value

[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public bool DisallowAdHocAccess { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property bool DisallowAdHocAccess {
    bool get ();
    void set (bool value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member DisallowAdHocAccess : bool with get, set

function get DisallowAdHocAccess () : boolean 
function set DisallowAdHocAccess (value : boolean)

属性值

类型：System.Boolean
A Boolean value that specifies whether SQL Server allows ad hoc functions with the OLE DB provider.If True, ad hoc functions are not allowed.If False (default), ad hoc function are allowed.

示例

在 SMO 中使用链接服务器

请参阅

参考

OleDbProviderSettings 类

Microsoft.SqlServer.Management.Smo 命名空间