AuditLevel Property
The AuditLevel property exposes SQL Server Authentication logging behavior.
Applies To
| IntegratedSecurity Object |
Syntax
object.AuditLevel [= value]
Parts
object
Expression that evaluates to an object in the Applies To list
value
Long integer specifying an authentication outcome as described in Settings
Data Type
Long, enumerated
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetAuditType(SQLDMO_AUDIT_TYPE* pRetVal);
HRESULT SetAuditType(SQLDMO_AUDIT_TYPE NewValue);
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 Microsoft Windows NT® 4.0 application log.
For more information about SQL Server security and access control, see Managing Security.