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);