共用方式為


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 命名空間