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