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 네임스페이스