| Event ID |
Description |
| 24000 |
Audit event in SQL server |
| 24001 |
Login succeeded in SQL server |
| 24002 |
Logout succeeded in SQL server |
| 24003 |
Login failed in SQL server |
| 24004 |
Change own password succeeded in SQL server |
| 24005 |
Change own password failed in SQL server |
| 24006 |
Change password succeeded in SQL server |
| 24007 |
Change password failed in SQL server |
| 24008 |
Reset own password succeeded in SQL server |
| 24009 |
Reset own password failed in SQL server |
| 24010 |
Reset password succeeded in SQL server |
| 24011 |
Reset password failed in SQL server |
| 24012 |
User must change password in SQL server |
| 24013 |
User account unlocked in SQL server |
| 24014 |
Application role password successfully changed in SQL server |
| 24015 |
Application role password change failed in SQL server |
| 24016 |
Add member to SQL server role succeeded |
| 24017 |
Add member to SQL server role failed |
| 24018 |
Remove member from SQL server role succeeded |
| 24019 |
Remove member from SQL server role failed |
| 24020 |
Add member to database role in SQL server succeeded |
| 24021 |
Add member to database role in SQL server failed |
| 24022 |
Remove member from database role in SQL server succeeded |
| 24023 |
Remove member from database role in SQL server failed |
| 24024 |
Database backup command issued in SQL server |
| 24025 |
Transaction log backup command issued in SQL server |
| 24026 |
Database restore command issued in SQL server |
| 24027 |
Transaction log restore command issued in SQL server |
| 24028 |
Database console command issued in SQL server |
| 24029 |
Bulk administration command issued in SQL server |
| 24030 |
Alter connection command issued in SQL server |
| 24031 |
Alter resources command issued in SQL server |
| 24032 |
Alter server state command issued in SQL server |
| 24033 |
Alter server settings command issuedin SQL server |
| 24034 |
View server state command issued in SQL server |
| 24035 |
External access assembly command issued in SQL server |
| 24036 |
Unsafe assembly command issued in SQL server |
| 24037 |
Alter resource governor command issued in SQL server |
| 24038 |
Database authenticate command issued in SQL server |
| 24039 |
Database checkpoint command issued in SQL server |
| 24040 |
Database show plan command issued in SQL server |
| 24041 |
Subscribe to query information command issued in SQL server |
| 24042 |
View database state command issued in SQL server |
| 24043 |
Change server audit command issued in SQL server |
| 24044 |
Change server audit specification command issued in SQL server |
| 24045 |
Change database audit specification command issued in SQL server |
| 24046 |
Create server audit command issued in SQL server |
| 24047 |
Create server audit specification command issued in SQL server |
| 24048 |
Create database audit specification command issued in SQL server |
| 24049 |
Delete server audit command issued in SQL server |
| 24050 |
Delete server audit specification command issued in SQL server |
| 24051 |
Delete database audit specification command issued in SQL server |
| 24052 |
Audit failure in SQL server |
| 24053 |
Audit session changed in SQL server |
| 24054 |
SQL server started |
| 24055 |
SQL server paused |
| 24056 |
SQL server resumed |
| 24057 |
SQL server stopped |
| 24058 |
Create server object command issued in SQL server |
| 24059 |
Change server object command issued in SQL server |
| 24060 |
Delete server object command issued in SQL server |
| 24061 |
Create server setting command issued in SQL server |
| 24062 |
Change server setting command issued in SQL server |
| 24063 |
Delete server setting command issued in SQL server |
| 24064 |
Create server cryptographic provider command issued in SQL server |
| 24065 |
Delete server cryptographic provider command issued in SQL server |
| 24066 |
Change server cryptographic provider command issued in SQL server |
| 24067 |
Create server credential command issued in SQL server |
| 24068 |
Delete server credential command issued in SQL server |
| 24069 |
Change server credential command issued in SQL server |
| 24070 |
Change server master key command issued in SQL server |
| 24071 |
Back up server master key command issued in SQL server |
| 24072 |
Restore server master key command issued in SQL server |
| 24073 |
Map server credential to login command issued in SQL server |
| 24074 |
Remove map between server credential and login command issued in SQL server |
| 24075 |
Create server principal command issued in SQL server |
| 24076 |
Delete server principal command issued in SQL server |
| 24077 |
Change server principal credentials command issued in SQL server |
| 24078 |
Disable server principal command issued in SQL server |
| 24079 |
Change server principal default database command issued in SQL server |
| 24080 |
Enable server principal command issued in SQL server |
| 24081 |
Change server principal default language command issued in SQL server |
| 24082 |
Change server principal password expiration command issued in SQL server |
| 24083 |
Change server principal password policy command issued in SQL server |
| 24084 |
Change server principal name command issued in SQL server |
| 24085 |
Create database command issued in SQL server |
| 24086 |
Change database command issued in SQL server |
| 24087 |
Delete database command issued in SQL server |
| 24088 |
Create certificate command issued in SQL server |
| 24089 |
Change certificate command issued in SQL server |
| 24090 |
Delete certificate command issued in SQL server |
| 24091 |
Back up certificate command issued in SQL server |
| 24092 |
Access certificate command issued in SQL server |
| 24093 |
Create asymmetric key command issued in SQL server |
| 24094 |
Change asymmetric key command issued in SQL server |
| 24095 |
Delete asymmetric key command issued in SQL server |
| 24096 |
Access asymmetric key command issued in SQL server |
| 24097 |
Create database master key command issued in SQL server |
| 24098 |
Change database master key command issued in SQL server |
| 24099 |
Delete database master key command issued in SQL server |
| 24100 |
Back up database master key command issued in SQL server |
| 24101 |
Restore database master key command in SQL server |
| 24102 |
Open database master key command issued in SQL server |
| 24103 |
Create database symmetric key command issued in SQL server |
| 24104 |
Change database symmetric key command issued in SQL server |
| 24105 |
Delete database symmetric key command issued in SQL server |
| 24106 |
Back up database symmetric key command issued in SQL server |
| 24107 |
Open database symmetric key command issued in SQL server |
| 24108 |
Create database object command issued in SQL server |
| 24109 |
Change database object command issued in SQL server |
| 24110 |
Delete database object command issued in SQL server |
| 24111 |
Access database object command issued in SQL server |
| 24112 |
Create assembly command issued in SQL server |
| 24113 |
Change assembly command issued in SQL server |
| 24114 |
Delete assembly command issued in SQL server |
| 24115 |
Create schema command issued in SQL server |
| 24116 |
Change schema command issued in SQL server |
| 24117 |
Delete schema command issued in SQL server |
| 24118 |
Create database encryption key command issued in SQL server |
| 24119 |
Change database encryption key command issued in SQL server |
| 24120 |
Delete database encryption key command issued in SQL server |
| 24121 |
Create database user command issued in SQL server |
| 24122 |
Change database user command issued in SQL server |
| 24123 |
Delete database user command issued in SQL server |
| 24124 |
Create database role command issued in SQL server |
| 24125 |
Change database role command issued in SQL server |
| 24126 |
Delete database role command issued in SQL server |
| 24127 |
Create application role command issued in SQL server |
| 24128 |
Change application role command issued in SQL server |
| 24129 |
Create application role command issued in SQL server |
| 24130 |
Change database user login command issued in SQL server |
| 24131 |
Auto-change database user login command issued in SQL server |
| 24132 |
Create schema object command issued in SQL server |
| 24133 |
Change schema object command issued in SQL server |
| 24134 |
Delete schema object command issued in SQL server |
| 24135 |
Transfer schema object command issued in SQL server |
| 24136 |
Create schema type command issued in SQL server |
| 24137 |
Change schema type command issued in SQL server |
| 24138 |
Delete schema type command issued in SQL server |
| 24139 |
Transfer schema type command issued in SQL server |
| 24140 |
Create XML schema collection command issued in SQL server |
| 24141 |
Change XML schema collection command issued in SQL server |
| 24142 |
Delete XML schema collection command issued in SQL server |
| 24143 |
Transfer XML schema collection command issued in SQL server |
| 24144 |
Impersonate within server scope command issued in SQL server |
| 24145 |
Impersonate within database scope command issued in SQL server |
| 24146 |
Change server object owner command issued in SQL server |
| 24147 |
Change database owner command issued in SQL server |
| 24148 |
Change schema owner command issued in SQL server |
| 24150 |
Change role owner command issued in SQL server |
| 24151 |
Change database object owner command issued in SQL server |
| 24152 |
Change symmetric key owner command issued in SQL server |
| 24153 |
Change certificate owner command issued in SQL server |
| 24154 |
Change asymmetric key owner command issued in SQL server |
| 24155 |
Change schema object owner command issued in SQL server |
| 24156 |
Change schema type owner command issued in SQL server |
| 24157 |
Change XML schema collection owner command issued in SQL server |
| 24158 |
Grant permissions succeeded in SQL server |
| 24159 |
Grant permissions failed in SQL server |
| 24160 |
Grant server permissions with grant succeeded in SQL server |
| 24161 |
Grant server permissions with grant failed in SQL server |
| 24162 |
Deny server permissions succeeded in SQL server |
| 24163 |
Deny server permissions failed in SQL server |
| 24164 |
Deny server permissions with cascade succeeded in SQL server |
| 24165 |
Deny server permissions with cascade failed in SQL server |
| 24166 |
Revoke server permissions succeeded in SQL server |
| 24167 |
Revoke server permissions failed in SQL server |
| 24168 |
Revoke server permissions with grant succeeded in SQL server |
| 24169 |
Revoke server permissions with grant failed in SQL server |
| 24170 |
Revoke server permissions with cascade succeeded in SQL server |
| 24171 |
Revoke server permissions with cascade failed in SQL server |
| 24172 |
Grant server object permissions command issued in SQL server |
| 24173 |
Grant server object permissions with grant command issued in SQL server |
| 24174 |
Deny server object permissions command issued in SQL server |
| 24175 |
Deny server object permissions with cascade command issued in SQL server |
| 24176 |
Revoke server object permissions command issued in SQL server |
| 24177 |
Revoke server object permissions with grant command issued in SQL server |
| 24178 |
Revoke server object permissions with cascade command issued in SQL server |
| 24179 |
Grant database permissions succeeded in SQL server |
| 24180 |
Grant database permissions failed in SQL server |
| 24181 |
Grant database permissions with grant succeeded in SQL server |
| 24182 |
Grant database permissions with grant failed in SQL server |
| 24183 |
Deny database permissions succeeded in SQL server |
| 24184 |
Deny database permissions failed in SQL server |
| 24185 |
Deny database permissions with cascade succeeded in SQL server |
| 24186 |
Deny database permissions with cascade failed in SQL server |
| 24187 |
Revoke database permissions succeeded in SQL server |
| 24188 |
Revoke server permissions failed in SQL server |
| 24189 |
Revoke database permissions with grant succeeded in SQL server |
| 24190 |
Revoke database permissions with grant failed in SQL server |
| 24191 |
Revoke database permissions with cascade succeeded in SQL server |
| 24192 |
Revoke database permissions with cascade failed in SQL server |
| 24193 |
Grant database object permissions command issued in SQL server |
| 24194 |
Grant database object permissions with grant command issued in SQL server |
| 24195 |
Deny server object permissions command issued in SQL server |
| 24196 |
Deny database object permissions with cascade command issued in SQL server |
| 24197 |
Revoke database object permissions command issued in SQL server |
| 24198 |
Revoke database object permissions with grant command issued in SQL server |
| 24199 |
Revoke database object permissions with cascade command issued in SQL server |
| 24200 |
Grant schema permissions command issued in SQL server |
| 24201 |
Grant schema permissions with grant command issued in SQL server |
| 24202 |
Deny schema permissions command issued in SQL server |
| 24203 |
Deny schema permissions with cascade command issued in SQL server |
| 24204 |
Revoke schema permissions command issued in SQL server |
| 24205 |
Revoke schema permissions with grant command issued in SQL server |
| 24206 |
Revoke schema permissions with cascade command issued in SQL server |
| 24207 |
Grant assembly permissions command issued in SQL server |
| 24208 |
Grant assembly permissions with grant command issued in SQL server |
| 24209 |
Deny assembly permissions command issued in SQL server |
| 24210 |
Deny assembly permissions with cascade command issued in SQL server |
| 24211 |
Revoke assembly permissions command issued in SQL server |
| 24212 |
Revoke assembly permissions with grant command issued in SQL server |
| 24213 |
Revoke assembly permissions with cascade command issued in SQL server |
| 24214 |
grant database role permissions command issued in SQL server |
| 24215 |
Grant database role permissions with grant command issued in SQL server |
| 24216 |
Deny database role permissions command issued in SQL server |
| 24217 |
Deny database role permissions with cascade command issued in SQL server |
| 24218 |
Revoke database role permissions command issued in SQL server |
| 24219 |
Revoke database role permissions with grant command issued in SQL server |
| 24220 |
Revoke database role permissions with cascade command issued in SQL server |
| 24221 |
Grant application role permissions command issued in SQL server |
| 24222 |
Grant application role permissions command issued in SQL server |
| 24223 |
Deny application role permissions command issued in SQL server |
| 24224 |
Deny application role permissions with cascade command issued in SQL server |
| 24225 |
Revoke application role permissions command issued in SQL server |
| 24226 |
Revoke application role permissions with grant command issued in SQL server |
| 24227 |
Revoke application role permissions with cascade command issued in SQL server |
| 24228 |
Grant symmetric key permissions command issued in SQL server |
| 24229 |
grant symmetric key permissions with grant command issued in SQL server |
| 24230 |
Deny symmetric key permissions command issued in SQL server |
| 24231 |
Deny symmetric key permissions with cascade command issued in SQL server |
| 24232 |
Revoke application role permissions command issued in SQL server |
| 24233 |
Revoke symmetric key permissions with grant command issued in SQL server |
| 24234 |
Revoke symmetric key permissions with grant command issued in SQL server |
| 24235 |
Grant certificate permissions command issued in SQL server |
| 24236 |
Grant certificate permissions with grant command issued in SQL server |
| 24237 |
Deny certificate permissions command issued in SQL server |
| 24238 |
Deny certificate permissions with cascade command issued in SQL server |
| 24239 |
Revoke certificate permissions command issued in SQL server |
| 24240 |
Revoke certificate permissions with grant command issued in SQL server |
| 24241 |
Revoke certificate permissions with cascade command issued in SQL server |
| 24242 |
Grant asymmetric key permissions command issued in SQL server |
| 24243 |
Grant asymmetric key permissions with grant command issued in SQL server |
| 24244 |
Deny asymmetric key permissions command issued in SQL server |
| 24245 |
Deny asymmetric key permissions with cascade command issued in SQL server |
| 24246 |
Revoke asymmetric key permissions command issued in SQL server |
| 24247 |
Revoke asymmetric key permissions with grant command issued in SQL server |
| 24248 |
Revoke asymmetric key permissions command issued in SQL server |
| 24249 |
Grant schema object permissions command issued in SQL server |
| 24250 |
Grant schema object permissions with grant command issued in SQL server |
| 24251 |
Deny schema object permissions command issued in SQL server |
| 24252 |
Deny schema object permissions with cascade command issued in SQL server |
| 24253 |
Revoke schema object permissions command issued in SQL server |
| 24254 |
Revoke schema object permissions with grant command issued in SQL server |
| 24255 |
Revoke schema object permissions with cascade command issued in SQL server |
| 24256 |
Grant schema type permissions command issued in SQL server |
| 24257 |
Grant schema type permissions with grant command issued in SQL server |
| 24258 |
Deny schema type permissions command issued in SQL server |
| 24259 |
Deny schema type permissions with cascade command issued in SQL server |
| 24260 |
Revoke schema type permissions command issued in SQL server |
| 24261 |
Revoke schema type permissions with grant command issued in SQL server |
| 24262 |
Revoke schema type permissions with cascade command issued in SQL server |
| 24263 |
Grant XML schema collection permissions command issued in SQL server |
| 24264 |
Grant XML schema collection permissions with grant command issued in SQL server |
| 24265 |
Deny XML schema collection permissions command issued in SQL server |
| 24266 |
Deny XML schema collection permissions with cascade command issued in SQL server |
| 24267 |
RevokeÿXML schema collection permissions command issued in SQL server |
| 24268 |
Revoke XML schema collection permissions with grant command issued in SQL server |
| 24269 |
Revoke XML schema collection permissions with cascade command issued in SQL server |
| 24270 |
Reference database object permissions command issued in SQL server |
| 24271 |
Send service request command issued in SQL server |
| 24272 |
Check permissions with schema command issued in SQL server |
| 24273 |
Use service broker transport security command issued in SQL server |
| 24274 |
Use database mirroring transport security command issued in SQL server |
| 24275 |
Alter trace command issued in SQL server |
| 24276 |
Start trace command issued in SQL server |
| 24277 |
Stop trace command issued in SQL server |
| 24278 |
Enable trace C2 audit mode command issued in SQL server |
| 24279 |
Disable trace C2 audit mode command issued in SQL server |
| 24280 |
Server full-text command issued in SQL server |
| 24281 |
Select command issued in SQL server |
| 24282 |
Update command issued in SQL server |
| 24283 |
Insert command issued in SQL server |
| 24284 |
Delete command issued in SQL server |
| 24285 |
Execute command issued in SQL server |
| 24286 |
Receive command issued in SQL server |
| 24287 |
Check references command issued in SQL server |
| 24288 |
Create user-defined server role command issued in SQL server |
| 24289 |
Change user-defined server role command issued in SQL server |
| 24290 |
Delete user-defined server role command issued in SQL server |
| 24291 |
Grant user-defined server role permissions command issued in SQL server |
| 24292 |
Grant user-defined server role permissions with grant command issued in SQL server |
| 24293 |
Deny user-defined server role permissions command issued in SQL server |
| 24294 |
Deny user-defined server role permissions with cascade command issued in SQL server |
| 24295 |
Revoke user-defined server role permissions command issued in SQL server |
| 24296 |
Revoke user-defined server role permissions with grant command issued in SQL server |
| 24297 |
Revoke user-defined server role permissions with cascade command issued in SQL server |
| 24298 |
Database login succeeded in SQL server |
| 24299 |
Database login failed in SQL server |
| 24300 |
Database logout succeeded in SQL server |
| 24301 |
Change database password succeeded in SQL server |
| 24302 |
Change database password failed in SQL server |
| 24303 |
Change own database password succeeded in SQL server |
| 24304 |
Change own database password failed in SQL server |
| 24305 |
Reset own database password succeeded in SQL server |
| 24306 |
Reset own password failed in SQL server |
| 24307 |
Reset database password succeeded in SQL server |
| 24308 |
Reset database password failed in SQL server |
| 24309 |
Copy passwordÿ in SQL server |
| 24310 |
User-defined audit eventÿin SQL server |
| 24311 |
Change database audit command issued in SQL server |
| 24312 |
Create database audit command issued in SQL server |
| 24313 |
Delete database audit command issued in SQL server |
| 24314 |
Begin transaction command issued in SQL server |
| 24315 |
Commit transaction command issued in SQL server |
| 24316 |
Rollback transaction command issued in SQL server |
| 24317 |
Create column master key command issued in SQL server |
| 24318 |
Delete column master key command issued in SQL server |
| 24319 |
Column master key viewed in SQL server |
| 24320 |
Create column encryption key command issued in SQL server |
| 24321 |
Change column encryption key command issued in SQL server |
| 24322 |
Delete column encryption key command issued in SQL server |
| 24323 |
Column encryption key viewed in SQL server |
| 24324 |
Create database credential command issued in SQL server |
| 24325 |
Change database credential command issued in SQL server |
| 24326 |
Delete database credential command issued in SQL server |
| 24327 |
Change database scoped configuration command issued in SQL server |
| 24328 |
Create external data source command issued in SQL server |
| 24329 |
Change external data source command issued in SQL server |
| 24330 |
Delete external data source command issued in SQL server |
| 24331 |
Create external file format command issued in SQL server |
| 24332 |
Delete external file format command issued in SQL server |
| 24333 |
Create external resource pool command issued in SQL server |
| 24334 |
Change external resource pool command issued in SQL server |
| 24335 |
Delete external resource pool command issued in SQL server |
| 24337 |
Global transaction login in SQL server |
| 24349 |
Change assembly owner command issued in SQL server |