AuditLevel Property (SQL-DMO)

The AuditLevel property exposes SQL Server Authentication logging behavior.

Applies To

IntegratedSecurity Object

Syntax

object.AuditLevel [= value]

Part Description
object Expression that evaluates to an object in the Applies To list
value Long integer specifying an authentication outcome as described in Settings

Settings
Constant Value Description
SQLDMOAudit_All 3 Log all authentication attempts regardless of success or failure
SQLDMOAudit_Failure 2 Log failed authentication
SQLDMOAudit_None 0 Do not log authentication attempts
SQLDMOAudit_Success 1 Log successful authentication

Remarks

SQL Server Authentication logging writes log entries to both the Microsoft® SQL Server™ error log and the Windows NT application log.

For more information about SQL Server security and access control, see Managing Security.

Data Type

Long, enumerated

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetAuditType(SQLDMO_AUDIT_TYPE* pRetVal);

HRESULT SetAuditType(SQLDMO_AUDIT_TYPE NewValue);

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.