EventType Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Sql Server event types
public enum EventTypetype EventType = Public Enum EventType- Inheritance
-
EventType
Fields
| Name | Value | Description |
|---|---|---|
| Unknown | 0 | Unknown |
| CreateTable | 21 | CreateTable |
| AlterTable | 22 | AlterTable |
| DropTable | 23 | DropTable |
| CreateIndex | 24 | CreateIndex |
| AlterIndex | 25 | AlterIndex |
| DropIndex | 26 | DropIndex |
| CreateStatistics | 27 | CreateStatistics |
| UpdateStatistics | 28 | UpdateStatistics |
| DropStatistics | 29 | DropStatistics |
| CreateSynonym | 34 | CreateSynonym |
| DropSynonym | 36 | DropSynonym |
| CreateView | 41 | CreateView |
| AlterView | 42 | AlterView |
| DropView | 43 | DropView |
| CreateProcedure | 51 | CreateProcedure |
| AlterProcedure | 52 | AlterProcedure |
| DropProcedure | 53 | DropProcedure |
| CreateFunction | 61 | CreateFunction |
| AlterFunction | 62 | AlterFunction |
| DropFunction | 63 | DropFunction |
| CreateTrigger | 71 | CreateTrigger |
| AlterTrigger | 72 | AlterTrigger |
| DropTrigger | 73 | DropTrigger |
| CreateEventNotification | 74 | CreateEventNotification |
| DropEventNotification | 76 | DropEventNotification |
| CreateType | 91 | CreateType |
| DropType | 93 | DropType |
| CreateAssembly | 101 | CreateAssembly |
| AlterAssembly | 102 | AlterAssembly |
| DropAssembly | 103 | DropAssembly |
| CreateUser | 131 | CreateUser |
| AlterUser | 132 | AlterUser |
| DropUser | 133 | DropUser |
| CreateRole | 134 | CreateRole |
| AlterRole | 135 | AlterRole |
| DropRole | 136 | DropRole |
| CreateApplicationRole | 137 | CreateApplicationRole |
| AlterApplicationRole | 138 | AlterApplicationRole |
| DropApplicationRole | 139 | DropApplicationRole |
| CreateSchema | 141 | CreateSchema |
| AlterSchema | 142 | AlterSchema |
| DropSchema | 143 | DropSchema |
| CreateLogin | 144 | CreateLogin |
| AlterLogin | 145 | AlterLogin |
| DropLogin | 146 | DropLogin |
| CreateMessageType | 151 | CreateMessageType |
| AlterMessageType | 152 | AlterMessageType |
| DropMessageType | 153 | DropMessageType |
| CreateContract | 154 | CreateContract |
| DropContract | 156 | DropContract |
| CreateQueue | 157 | CreateQueue |
| AlterQueue | 158 | AlterQueue |
| DropQueue | 159 | DropQueue |
| BrokerQueueDisabled | 160 | BrokerQueueDisabled |
| CreateService | 161 | CreateService |
| AlterService | 162 | AlterService |
| DropService | 163 | DropService |
| CreateRoute | 164 | CreateRoute |
| AlterRoute | 165 | AlterRoute |
| DropRoute | 166 | DropRoute |
| GrantServer | 167 | GrantServer |
| DenyServer | 168 | DenyServer |
| RevokeServer | 169 | RevokeServer |
| GrantDatabase | 170 | GrantDatabase |
| DenyDatabase | 171 | DenyDatabase |
| RevokeDatabase | 172 | RevokeDatabase |
| QueueActivation | 173 | QueueActivation |
| CreateRemoteServiceBinding | 174 | CreateRemoteServiceBinding |
| AlterRemoteServiceBinding | 175 | AlterRemoteServiceBinding |
| DropRemoteServiceBinding | 176 | DropRemoteServiceBinding |
| CreateXmlSchemaCollection | 177 | CreateXmlSchemaCollection |
| AlterXmlSchemaCollection | 178 | AlterXmlSchemaCollection |
| DropXmlSchemaCollection | 179 | DropXmlSchemaCollection |
| CreateEndpoint | 181 | CreateEndpoint |
| AlterEndpoint | 182 | AlterEndpoint |
| DropEndpoint | 183 | DropEndpoint |
| CreatePartitionFunction | 191 | CreatePartitionFunction |
| AlterPartitionFunction | 192 | AlterPartitionFunction |
| DropPartitionFunction | 193 | DropPartitionFunction |
| CreatePartitionScheme | 194 | CreatePartitionScheme |
| AlterPartitionScheme | 195 | AlterPartitionScheme |
| DropPartitionScheme | 196 | DropPartitionScheme |
| CreateCertificate | 197 | CreateCertificate |
| AlterCertificate | 198 | AlterCertificate |
| DropCertificate | 199 | DropCertificate |
| CreateDatabase | 201 | CreateDatabase |
| AlterDatabase | 202 | AlterDatabase |
| DropDatabase | 203 | DropDatabase |
| AlterAuthorizationServer | 204 | AlterAuthorizationServer |
| AlterAuthorizationDatabase | 205 | AlterAuthorizationDatabase |
| CreateXmlIndex | 206 | CreateXmlIndex |
| AddRoleMember | 207 | AddRoleMember |
| DropRoleMember | 208 | DropRoleMember |
| AddServerRoleMember | 209 | AddServerRoleMember |
| DropServerRoleMember | 210 | DropServerRoleMember |
| AlterExtendedProperty | 211 | AlterExtendedProperty |
| AlterFullTextCatalog | 212 | AlterFullTextCatalog |
| AlterFullTextIndex | 213 | AlterFullTextIndex |
| AlterInstance | 214 | AlterInstance |
| AlterMessage | 215 | AlterMessage |
| AlterPlanGuide | 216 | AlterPlanGuide |
| AlterRemoteServer | 217 | AlterRemoteServer |
| BindDefault | 218 | BindDefault |
| BindRule | 219 | BindRule |
| CreateDefault | 220 | CreateDefault |
| CreateExtendedProcedure | 221 | CreateExtendedProcedure |
| CreateExtendedProperty | 222 | CreateExtendedProperty |
| CreateFullTextCatalog | 223 | CreateFullTextCatalog |
| CreateFullTextIndex | 224 | CreateFullTextIndex |
| CreateLinkedServer | 225 | CreateLinkedServer |
| CreateLinkedServerLogin | 226 | CreateLinkedServerLogin |
| CreateMessage | 227 | CreateMessage |
| CreatePlanGuide | 228 | CreatePlanGuide |
| CreateRule | 229 | CreateRule |
| CreateRemoteServer | 230 | CreateRemoteServer |
| DropDefault | 231 | DropDefault |
| DropExtendedProcedure | 232 | DropExtendedProcedure |
| DropExtendedProperty | 233 | DropExtendedProperty |
| DropFullTextCatalog | 234 | DropFullTextCatalog |
| DropFullTextIndex | 235 | DropFullTextIndex |
| DropLinkedServerLogin | 236 | DropLinkedServerLogin |
| DropMessage | 237 | DropMessage |
| DropPlanGuide | 238 | DropPlanGuide |
| DropRule | 239 | DropRule |
| DropRemoteServer | 240 | DropRemoteServer |
| Rename | 241 | Rename |
| UnbindDefault | 242 | UnbindDefault |
| UnbindRule | 243 | UnbindRule |
| CreateSymmetricKey | 244 | CreateSymmetricKey |
| AlterSymmetricKey | 245 | AlterSymmetricKey |
| DropSymmetricKey | 246 | DropSymmetricKey |
| CreateAsymmetricKey | 247 | CreateAsymmetricKey |
| AlterAsymmetricKey | 248 | AlterAsymmetricKey |
| DropAsymmetricKey | 249 | DropAsymmetricKey |
| AlterServiceMasterKey | 251 | AlterServiceMasterKey |
| CreateMasterKey | 252 | CreateMasterKey |
| AlterMasterKey | 253 | AlterMasterKey |
| DropMasterKey | 254 | DropMasterKey |
| AddSignatureSchemaObject | 255 | AddSignatureSchemaObject |
| DropSignatureSchemaObject | 256 | DropSignatureSchemaObject |
| AddSignature | 257 | AddSignature |
| DropSignature | 258 | DropSignature |
| CreateCredential | 259 | CreateCredential |
| AlterCredential | 260 | AlterCredential |
| DropCredential | 261 | DropCredential |
| DropLinkedServer | 262 | DropLinkedServer |
| AlterLinkedServer | 263 | AlterLinkedServer |
| CreateEventSession | 264 | CreateEventSession |
| AlterEventSession | 265 | AlterEventSession |
| DropEventSession | 266 | DropEventSession |
| CreateResourcePool | 267 | CreateResourcePool |
| AlterResourcePool | 268 | AlterResourcePool |
| DropResourcePool | 269 | DropResourcePool |
| CreateWorkloadGroup | 270 | CreateWorkloadGroup |
| AlterWorkloadGroup | 271 | AlterWorkloadGroup |
| DropWorkloadGroup | 272 | DropWorkloadGroup |
| AlterResourceGovernorConfig | 273 | AlterResourceGovernorConfig |
| CreateSpatialIndex | 274 | CreateSpatialIndex |
| CreateCryptographicProvider | 275 | CreateCryptographicProvider |
| AlterCryptographicProvider | 276 | AlterCryptographicProvider |
| DropCryptographicProvider | 277 | DropCryptographicProvider |
| CreateDatabaseEncryptionKey | 278 | CreateDatabaseEncryptionKey |
| AlterDatabaseEncryptionKey | 279 | AlterDatabaseEncryptionKey |
| DropDatabaseEncryptionKey | 280 | DropDatabaseEncryptionKey |
| CreateBrokerPriority | 281 | CreateBrokerPriority |
| AlterBrokerPriority | 282 | AlterBrokerPriority |
| DropBrokerPriority | 283 | DropBrokerPriority |
| CreateServerAudit | 284 | CreateServerAudit |
| AlterServerAudit | 285 | AlterServerAudit |
| DropServerAudit | 286 | DropServerAudit |
| CreateServerAuditSpecification | 287 | CreateServerAuditSpecification |
| AlterServerAuditSpecification | 288 | AlterServerAuditSpecification |
| DropServerAuditSpecification | 289 | DropServerAuditSpecification |
| CreateDatabaseAuditSpecification | 290 | CreateDatabaseAuditSpecification |
| AlterDatabaseAuditSpecification | 291 | AlterDatabaseAuditSpecification |
| DropDatabaseAuditSpecification | 292 | DropDatabaseAuditSpecification |
| CreateFullTextStopList | 293 | CreateFullTextStopList |
| AlterFullTextStopList | 294 | AlterFullTextStopList |
| DropFullTextStopList | 295 | DropFullTextStopList |
| AlterServerConfiguration | 296 | AlterServerConfiguration |
| CreateSearchPropertyList | 297 | CreateSearchPropertyList |
| AlterSearchPropertyList | 298 | AlterSearchPropertyList |
| DropSearchPropertyList | 299 | DropSearchPropertyList |
| CreateServerRole | 300 | CreateServerRole |
| AlterServerRole | 301 | AlterServerRole |
| DropServerRole | 302 | DropServerRole |
| CreateSequence | 303 | CreateSequence |
| AlterSequence | 304 | AlterSequence |
| DropSequence | 305 | DropSequence |
| CreateAvailabilityGroup | 306 | CreateAvailabilityGroup |
| AlterAvailabilityGroup | 307 | AlterAvailabilityGroup |
| DropAvailabilityGroup | 308 | DropAvailabilityGroup |
| CreateDatabaseAudit | 309 | CreateDatabaseAudit |
| DropDatabaseAudit | 310 | DropDatabaseAudit |
| AlterDatabaseAudit | 311 | AlterDatabaseAudit |
| CreateSecurityPolicy | 312 | CreateSecurityPolicy |
| AlterSecurityPolicy | 313 | AlterSecurityPolicy |
| DropSecurityPolicy | 314 | DropSecurityPolicy |
| CreateColumnMasterKey | 315 | CreateColumnMasterKey |
| DropColumnMasterKey | 316 | DropColumnMasterKey |
| CreateColumnEncryptionKey | 317 | CreateColumnEncryptionKey |
| AlterColumnEncryptionKey | 318 | AlterColumnEncryptionKey |
| DropColumnEncryptionKey | 319 | DropColumnEncryptionKey |
| AlterDatabaseScopedConfiguration | 320 | AlterDatabaseScopedConfiguration |
| CreateExternalResourcePool | 321 | CreateExternalResourcePool |
| AlterExternalResourcePool | 322 | AlterExternalResourcePool |
| DropExternalResourcePool | 323 | DropExternalResourcePool |
| CreateExternalLibrary | 324 | CreateExternalLibrary |
| AlterExternalLibrary | 325 | AlterExternalLibrary |
| DropExternalLibrary | 326 | DropExternalLibrary |
| AddSensitivityClassification | 327 | AddSensitivityClassification |
| DropSensitivityClassification | 328 | DropSensitivityClassification |
| CreateExternalLanguage | 329 | CreateExternalLanguage |
| AlterExternalLanguage | 330 | AlterExternalLanguage |
| DropExternalLanguage | 331 | DropExternalLanguage |
| AuditLogin | 1014 | AuditLogin |
| AuditLogout | 1015 | AuditLogout |
| AuditLoginFailed | 1020 | AuditLoginFailed |
| EventLog | 1021 | EventLog |
| ErrorLog | 1022 | ErrorLog |
| LockDeadlock | 1025 | LockDeadlock |
| Exception | 1033 | Exception |
| SpCacheMiss | 1034 | SpCacheMiss |
| SpCacheInsert | 1035 | SpCacheInsert |
| SpCacheRemove | 1036 | SpCacheRemove |
| SpRecompile | 1037 | SpRecompile |
| ObjectCreated | 1046 | ObjectCreated |
| ObjectDeleted | 1047 | ObjectDeleted |
| HashWarning | 1055 | HashWarning |
| LockDeadlockChain | 1059 | LockDeadlockChain |
| LockEscalation | 1060 | LockEscalation |
| OledbErrors | 1061 | OledbErrors |
| ExecutionWarnings | 1067 | ExecutionWarnings |
| SortWarnings | 1069 | SortWarnings |
| MissingColumnStatistics | 1079 | MissingColumnStatistics |
| MissingJoinPredicate | 1080 | MissingJoinPredicate |
| ServerMemoryChange | 1081 | ServerMemoryChange |
| UserConfigurable0 | 1082 | UserConfigurable0 |
| UserConfigurable1 | 1083 | UserConfigurable1 |
| UserConfigurable2 | 1084 | UserConfigurable2 |
| UserConfigurable3 | 1085 | UserConfigurable3 |
| UserConfigurable4 | 1086 | UserConfigurable4 |
| UserConfigurable5 | 1087 | UserConfigurable5 |
| UserConfigurable6 | 1088 | UserConfigurable6 |
| UserConfigurable7 | 1089 | UserConfigurable7 |
| UserConfigurable8 | 1090 | UserConfigurable8 |
| UserConfigurable9 | 1091 | UserConfigurable9 |
| DataFileAutoGrow | 1092 | DataFileAutoGrow |
| LogFileAutoGrow | 1093 | LogFileAutoGrow |
| DataFileAutoShrink | 1094 | DataFileAutoShrink |
| LogFileAutoShrink | 1095 | LogFileAutoShrink |
| AuditDatabaseScopeGdrEvent | 1102 | AuditDatabaseScopeGdrEvent |
| AuditSchemaObjectGdrEvent | 1103 | AuditSchemaObjectGdrEvent |
| AuditAddLoginEvent | 1104 | AuditAddLoginEvent |
| AuditLoginGdrEvent | 1105 | AuditLoginGdrEvent |
| AuditLoginChangePropertyEvent | 1106 | AuditLoginChangePropertyEvent |
| AuditLoginChangePasswordEvent | 1107 | AuditLoginChangePasswordEvent |
| AuditAddLoginToServerRoleEvent | 1108 | AuditAddLoginToServerRoleEvent |
| AuditAddDbUserEvent | 1109 | AuditAddDbUserEvent |
| AuditAddMemberToDbRoleEvent | 1110 | AuditAddMemberToDbRoleEvent |
| AuditAddRoleEvent | 1111 | AuditAddRoleEvent |
| AuditAppRoleChangePasswordEvent | 1112 | AuditAppRoleChangePasswordEvent |
| AuditSchemaObjectAccessEvent | 1114 | AuditSchemaObjectAccessEvent |
| AuditBackupRestoreEvent | 1115 | AuditBackupRestoreEvent |
| AuditDbccEvent | 1116 | AuditDbccEvent |
| AuditChangeAuditEvent | 1117 | AuditChangeAuditEvent |
| OledbCallEvent | 1119 | OledbCallEvent |
| OledbQueryInterfaceEvent | 1120 | OledbQueryInterfaceEvent |
| OledbDataReadEvent | 1121 | OledbDataReadEvent |
| ShowPlanXml | 1122 | ShowPlanXml |
| DeprecationAnnouncement | 1125 | DeprecationAnnouncement |
| DeprecationFinalSupport | 1126 | DeprecationFinalSupport |
| ExchangeSpillEvent | 1127 | ExchangeSpillEvent |
| AuditDatabaseManagementEvent | 1128 | AuditDatabaseManagementEvent |
| AuditDatabaseObjectManagementEvent | 1129 | AuditDatabaseObjectManagementEvent |
| AuditDatabasePrincipalManagementEvent | 1130 | AuditDatabasePrincipalManagementEvent |
| AuditSchemaObjectManagementEvent | 1131 | AuditSchemaObjectManagementEvent |
| AuditServerPrincipalImpersonationEvent | 1132 | AuditServerPrincipalImpersonationEvent |
| AuditDatabasePrincipalImpersonationEvent | 1133 | AuditDatabasePrincipalImpersonationEvent |
| AuditServerObjectTakeOwnershipEvent | 1134 | AuditServerObjectTakeOwnershipEvent |
| AuditDatabaseObjectTakeOwnershipEvent | 1135 | AuditDatabaseObjectTakeOwnershipEvent |
| BlockedProcessReport | 1137 | BlockedProcessReport |
| ShowPlanXmlStatisticsProfile | 1146 | ShowPlanXmlStatisticsProfile |
| DeadlockGraph | 1148 | DeadlockGraph |
| TraceFileClose | 1150 | TraceFileClose |
| AuditChangeDatabaseOwner | 1152 | AuditChangeDatabaseOwner |
| AuditSchemaObjectTakeOwnershipEvent | 1153 | AuditSchemaObjectTakeOwnershipEvent |
| FtCrawlStarted | 1155 | FtCrawlStarted |
| FtCrawlStopped | 1156 | FtCrawlStopped |
| FtCrawlAborted | 1157 | FtCrawlAborted |
| UserErrorMessage | 1162 | UserErrorMessage |
| ObjectAltered | 1164 | ObjectAltered |
| SqlStmtRecompile | 1166 | SqlStmtRecompile |
| DatabaseMirroringStateChange | 1167 | DatabaseMirroringStateChange |
| ShowPlanXmlForQueryCompile | 1168 | ShowPlanXmlForQueryCompile |
| ShowPlanAllForQueryCompile | 1169 | ShowPlanAllForQueryCompile |
| AuditServerScopeGdrEvent | 1170 | AuditServerScopeGdrEvent |
| AuditServerObjectGdrEvent | 1171 | AuditServerObjectGdrEvent |
| AuditDatabaseObjectGdrEvent | 1172 | AuditDatabaseObjectGdrEvent |
| AuditServerOperationEvent | 1173 | AuditServerOperationEvent |
| AuditServerAlterTraceEvent | 1175 | AuditServerAlterTraceEvent |
| AuditServerObjectManagementEvent | 1176 | AuditServerObjectManagementEvent |
| AuditServerPrincipalManagementEvent | 1177 | AuditServerPrincipalManagementEvent |
| AuditDatabaseOperationEvent | 1178 | AuditDatabaseOperationEvent |
| AuditDatabaseObjectAccessEvent | 1180 | AuditDatabaseObjectAccessEvent |
| OledbProviderInformation | 1194 | OledbProviderInformation |
| MountTape | 1195 | MountTape |
| AssemblyLoad | 1196 | AssemblyLoad |
| XQueryStaticType | 1198 | XQueryStaticType |
| QnSubscription | 1199 | QnSubscription |
| QnParameterTable | 1200 | QnParameterTable |
| QnTemplate | 1201 | QnTemplate |
| QnDynamics | 1202 | QnDynamics |
| BitmapWarning | 1212 | BitmapWarning |
| DatabaseSuspectDataPage | 1213 | DatabaseSuspectDataPage |
| CpuThresholdExceeded | 1214 | CpuThresholdExceeded |
| AuditFullText | 1235 | AuditFullText |