The AuditLevel property exposes SQL Server Authentication logging behavior.
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 |
| 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 |
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.
Long, enumerated
Read/write
HRESULT GetAuditType(SQLDMO_AUDIT_TYPE* pRetVal);
HRESULT SetAuditType(SQLDMO_AUDIT_TYPE NewValue);