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