SQL Server Audit Log Event ID 24000
SourceSQL Server (LOGbinder SQL)
Action GroupNot applicable
Windows Security Log
Category
 • Subcategory
Object Access
 • Application Generated
Type Success
Discussions on Event ID 24000
Ask a question about this event

24000: SQL audit event

This is a SQL Server audit event from LOGbinder SQL generated by Action Group  Not applicable.

On this page

Undocumented SQL audit event

FieldDescription
OccurredWhen event was reported by SQL Server
ActionID of the SQL Audit Action. See sys.dm_audit_actions on TechNet.
Succeeded"True" or "False"
Permission bitmaskWhen applicable, shows the permissions that were granted, denied, or revoked
Is column permissionFlag indicating a column level permission
Session IDID of the session on which the event occurred
Server principal IDID of the login context that the action is performed in.
Database principal IDCurrent user
Target server principal IDTarget login of the action
Target database principal IDDatabase principal that the auditable action applies to.
Object IDThe primary ID of the entity on which the audit occurred. This includes: server objects, databases, database objects or schema objects
Class typeType of auditable entity that the audit occurs on. See SQL Server Audit Records on TechNet.
Session server principal nameServer principal for the session
Server principal nameCurrent Login
Server principal SIDCurrent login SID
OccurredWhen event was reported by SQL Server
Database principal nameCurrent user
Target server principal nameTarget login of the action
Target server principal SIDTarget login's SID of the action
Target database principal nameDatabase principal that the auditable action applies to.
Server instance nameName of the server instance where the audit occurred. Uses the standard machine\instance format.
Database nameDatabase affected by the event
Schema nameSchema context in which the action occurred
Object nameName of the entity on which the audit occurred. This includes: server objects, databases, database objects or schema objects
StatementTransact-SQL statement
Additional informationAny additional information about the event, stored as XML.

Top 10 Windows Security Events to Monitor

Keep me up-to-date on the Windows Security Log.
Email*:
*We will NOT share this

Where Does This Event Come From?

This Event Is Produced By