다음을 통해 공유

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