EventNotificationEventType
Possible event types
AddRoleMember = 207
ADD_ROLE_MEMBER.
ADD_SENSITIVITY_CLASSIFICATION
AddServerRoleMember = 209
ADD_SERVER_ROLE_MEMBER.
AddSignature = 257
ADD_SIGNATURE.
AddSignatureSchemaObject = 255
ADD_SIGNATURE_SCHEMA_OBJECT.
AlterApplicationRole = 138
ALTER_APPLICATION_ROLE.
AlterAssembly = 102
ALTER_ASSEMBLY.
AlterAsymmetricKey = 248
ALTER_ASYMMETRIC_KEY.
ALTER_AUTHORIZATION_DATABASE.
AlterAuthorizationServer = 204
ALTER_AUTHORIZATION_SERVER.
AlterAvailabilityGroup = 307
ALTER_AVAILABILITY_GROUP.
AlterBrokerPriority = 282
ALTER_BROKER_PRIORITY.
AlterCertificate = 198
ALTER_CERTIFICATE.
AlterColumnEncryptionKey = 318
ALTER_COLUMN_ENCRYPTION_KEY
AlterCredential = 260
ALTER_CREDENTIAL.
ALTER_CRYPTOGRAPHIC_PROVIDER.
AlterDatabase = 202
ALTER_DATABASE.
AlterDatabaseAudit = 311
ALTER_AUDIT.
ALTER_DATABASE_AUDIT_SPECIFICATION.
ALTER_DATABASE_ENCRYPTION_KEY.
ALTER_DATABASE_SCOPED_CONFIGURATION
AlterEndpoint = 182
ALTER_ENDPOINT.
AlterEventSession = 265
ALTER_EVENT_SESSION.
AlterExtendedProperty = 211
ALTER_EXTENDED_PROPERTY.
AlterExternalLanguage = 330
ALTER_EXTERNAL_LANGUAGE
AlterExternalLibrary = 325
ALTER_EXTERNAL_LIBRARY
ALTER_EXTERNAL_RESOURCE_POOL
AlterFullTextCatalog = 212
ALTER_FULLTEXT_CATALOG.
AlterFullTextIndex = 213
ALTER_FULLTEXT_INDEX.
AlterFullTextStopList = 294
ALTER_FULLTEXT_STOPLIST.
AlterFunction = 62
ALTER_FUNCTION.
AlterIndex = 25
ALTER_INDEX.
AlterInstance = 214
ALTER_INSTANCE.
AlterLinkedServer = 263
ALTER_LINKED_SERVER.
AlterLogin = 145
ALTER_LOGIN.
AlterMasterKey = 253
ALTER_MASTER_KEY.
AlterMessage = 215
ALTER_MESSAGE.
AlterMessageType = 152
ALTER_MESSAGE_TYPE.
AlterPartitionFunction = 192
ALTER_PARTITION_FUNCTION.
AlterPartitionScheme = 195
ALTER_PARTITION_SCHEME.
AlterPlanGuide = 216
ALTER_PLAN_GUIDE.
AlterProcedure = 52
ALTER_PROCEDURE.
AlterQueue = 158
ALTER_QUEUE.
AlterRemoteServer = 217
ALTER_REMOTE_SERVER.
ALTER_REMOTE_SERVICE_BINDING.
ALTER_RESOURCE_GOVERNOR_CONFIG.
AlterResourcePool = 268
ALTER_RESOURCE_POOL.
AlterRole = 135
ALTER_ROLE.
AlterRoute = 165
ALTER_ROUTE.
AlterSchema = 142
ALTER_SCHEMA.
AlterSearchPropertyList = 298
ALTER_SEARCH_PROPERTY_LIST.
AlterSecurityPolicy = 313
ALTER SECURITY POLICY
AlterSequence = 304
ALTER_SEQUENCE.
AlterServerAudit = 285
ALTER_SERVER_AUDIT.
ALTER_SERVER_AUDIT_SPECIFICATION.
AlterServerConfiguration = 296
ALTER_SERVER_CONFIGURATION.
AlterServerRole = 301
ALTER_SERVER_ROLE.
AlterService = 162
ALTER_SERVICE.
AlterServiceMasterKey = 251
ALTER_SERVICE_MASTER_KEY.
AlterSymmetricKey = 245
ALTER_SYMMETRIC_KEY.
AlterTable = 22
ALTER_TABLE.
AlterTrigger = 72
ALTER_TRIGGER.
AlterUser = 132
ALTER_USER.
AlterView = 42
ALTER_VIEW.
AlterWorkloadGroup = 271
ALTER_WORKLOAD_GROUP.
AlterXmlSchemaCollection = 178
ALTER_XML_SCHEMA_COLLECTION.
AssemblyLoad = 1196
ASSEMBLY_LOAD.
AuditAddDBUserEvent = 1109
AUDIT_ADD_DB_USER_EVENT.
AuditAddLoginEvent = 1104
AUDIT_ADDLOGIN_EVENT.
AUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENT.
AuditAddMemberToDBRoleEvent = 1110
AUDIT_ADD_MEMBER_TO_DB_ROLE_EVENT.
AuditAddRoleEvent = 1111
AUDIT_ADD_ROLE_EVENT.
AUDIT_APP_ROLE_CHANGE_PASSWORD_EVENT.
AuditBackupRestoreEvent = 1115
AUDIT_BACKUP_RESTORE_EVENT.
AuditChangeAuditEvent = 1117
AUDIT_CHANGE_AUDIT_EVENT.
AuditChangeDatabaseOwner = 1152
AUDIT_CHANGE_DATABASE_OWNER.
AuditDatabaseManagementEvent = 1128
AUDIT_DATABASE_MANAGEMENT_EVENT.
AUDIT_DATABASE_OBJECT_ACCESS_EVENT.
AuditDatabaseObjectGdrEvent = 1172
AUDIT_DATABASE_OBJECT_GDR_EVENT.
AUDIT_DATABASE_OBJECT_MANAGEMENT_EVENT.
AUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENT.
AuditDatabaseOperationEvent = 1178
AUDIT_DATABASE_OPERATION_EVENT.
AUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENT.
AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT.
AuditDatabaseScopeGdrEvent = 1102
AUDIT_DATABASE_SCOPE_GDR_EVENT.
AuditDbccEvent = 1116
AUDIT_DBCC_EVENT.
AuditFullText = 1235
AUDIT_FULLTEXT.
AuditLogin = 1014
AUDIT_LOGIN.
AUDIT_LOGIN_CHANGE_PASSWORD_EVENT.
AUDIT_LOGIN_CHANGE_PROPERTY_EVENT.
AuditLoginFailed = 1020
AUDIT_LOGIN_FAILED.
AuditLoginGdrEvent = 1105
AUDIT_LOGIN_GDR_EVENT.
AuditLogout = 1015
AUDIT_LOGOUT.
AuditSchemaObjectAccessEvent = 1114
AUDIT_SCHEMA_OBJECT_ACCESS_EVENT.
AuditSchemaObjectGdrEvent = 1103
AUDIT_SCHEMA_OBJECT_GDR_EVENT.
AUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT.
AUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENT.
AuditServerAlterTraceEvent = 1175
AUDIT_SERVER_ALTER_TRACE_EVENT.
AuditServerObjectGdrEvent = 1171
AUDIT_SERVER_OBJECT_GDR_EVENT.
AUDIT_SERVER_OBJECT_MANAGEMENT_EVENT.
AUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENT.
AuditServerOperationEvent = 1173
AUDIT_SERVER_OPERATION_EVENT.
AUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENT.
AUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT.
AuditServerScopeGdrEvent = 1170
AUDIT_SERVER_SCOPE_GDR_EVENT.
BindDefault = 218
BIND_DEFAULT.
BindRule = 219
BIND_RULE.
BitmapWarning = 1212
BITMAP_WARNING.
BlockedProcessReport = 1137
BLOCKED_PROCESS_REPORT.
BrokerQueueDisabled = 160
BROKER_QUEUE_DISABLED.
CpuThresholdExceeded = 1214
CPU_THRESHOLD_EXCEEDED.
CreateApplicationRole = 137
CREATE_APPLICATION_ROLE.
CreateAssembly = 101
CREATE_ASSEMBLY.
CreateAsymmetricKey = 247
CREATE_ASYMMETRIC_KEY.
CreateAvailabilityGroup = 306
CREATE_AVAILABILITY_GROUP.
CreateBrokerPriority = 281
CREATE_BROKER_PRIORITY.
CreateCertificate = 197
CREATE_CERTIFICATE.
CREATE_COLUMN_ENCRYPTION_KEY
CreateColumnMasterKey = 315
CREATE_COLUMN_MASTER_KEY
CreateContract = 154
CREATE_CONTRACT.
CreateCredential = 259
CREATE_CREDENTIAL.
CREATE_CRYPTOGRAPHIC_PROVIDER.
CreateDatabase = 201
CREATE_DATABASE.
CreateDatabaseAudit = 309
CREATE_AUDIT.
CREATE_DATABASE_AUDIT_SPECIFICATION.
CREATE_DATABASE_ENCRYPTION_KEY.
CreateDefault = 220
CREATE_DEFAULT.
CreateEndpoint = 181
CREATE_ENDPOINT.
CREATE_EVENT_NOTIFICATION.
CreateEventSession = 264
CREATE_EVENT_SESSION.
CreateExtendedProcedure = 221
CREATE_EXTENDED_PROCEDURE.
CreateExtendedProperty = 222
CREATE_EXTENDED_PROPERTY.
CreateExternalLanguage = 329
CREATE_EXTERNAL_LANGUAGE
CreateExternalLibrary = 324
CREATE_EXTERNAL_LIBRARY
CREATE_EXTERNAL_RESOURCE_POOL
CreateFullTextCatalog = 223
CREATE_FULLTEXT_CATALOG.
CreateFullTextIndex = 224
CREATE_FULLTEXT_INDEX.
CreateFullTextStopList = 293
CREATE_FULLTEXT_STOPLIST.
CreateFunction = 61
CREATE_FUNCTION.
CreateIndex = 24
CREATE_INDEX.
CreateLinkedServer = 225
CREATE_LINKED_SERVER.
CreateLinkedServerLogin = 226
CREATE_LINKED_SERVER_LOGIN.
CreateLogin = 144
CREATE_LOGIN.
CreateMasterKey = 252
CREATE_MASTER_KEY.
CreateMessage = 227
CREATE_MESSAGE.
CreateMessageType = 151
CREATE_MESSAGE_TYPE.
CreatePartitionFunction = 191
CREATE_PARTITION_FUNCTION.
CreatePartitionScheme = 194
CREATE_PARTITION_SCHEME.
CreatePlanGuide = 228
CREATE_PLAN_GUIDE.
CreateProcedure = 51
CREATE_PROCEDURE.
CreateQueue = 157
CREATE_QUEUE.
CreateRemoteServer = 230
CREATE_REMOTE_SERVER.
CREATE_REMOTE_SERVICE_BINDING.
CreateResourcePool = 267
CREATE_RESOURCE_POOL.
CreateRole = 134
CREATE_ROLE.
CreateRoute = 164
CREATE_ROUTE.
CreateRule = 229
CREATE_RULE.
CreateSchema = 141
CREATE_SCHEMA.
CreateSearchPropertyList = 297
CREATE_SEARCH_PROPERTY_LIST.
CreateSecurityPolicy = 312
CREATE SECURITY POLICY
CreateSequence = 303
CREATE_SEQUENCE.
CreateServerAudit = 284
CREATE_SERVER_AUDIT.
CREATE_SERVER_AUDIT_SPECIFICATION.
CreateServerRole = 300
CREATE_SERVER_ROLE.
CreateService = 161
CREATE_SERVICE.
CreateSpatialIndex = 274
CREATE_SPATIAL_INDEX.
CreateStatistics = 27
CREATE_STATISTICS.
CreateSymmetricKey = 244
CREATE_SYMMETRIC_KEY.
CreateSynonym = 34
CREATE_SYNONYM.
CreateTable = 21
CREATE_TABLE.
CreateTrigger = 71
CREATE_TRIGGER.
CreateType = 91
CREATE_TYPE.
CreateUser = 131
CREATE_USER.
CreateView = 41
CREATE_VIEW.
CreateWorkloadGroup = 270
CREATE_WORKLOAD_GROUP.
CreateXmlIndex = 206
CREATE_XML_INDEX.
CREATE_XML_SCHEMA_COLLECTION.
DatabaseMirroringStateChange = 1167
DATABASE_MIRRORING_STATE_CHANGE.
DatabaseSuspectDataPage = 1213
DATABASE_SUSPECT_DATA_PAGE.
DataFileAutoGrow = 1092
DATA_FILE_AUTO_GROW.
DataFileAutoShrink = 1094
DATA_FILE_AUTO_SHRINK.
DeadlockGraph = 1148
DEADLOCK_GRAPH.
DenyDatabase = 171
DENY_DATABASE.
DenyServer = 168
DENY_SERVER.
DeprecationAnnouncement = 1125
DEPRECATION_ANNOUNCEMENT.
DeprecationFinalSupport = 1126
DEPRECATION_FINAL_SUPPORT.
DropApplicationRole = 139
DROP_APPLICATION_ROLE.
DropAssembly = 103
DROP_ASSEMBLY.
DropAsymmetricKey = 249
DROP_ASYMMETRIC_KEY.
DropAvailabilityGroup = 308
DROP_AVAILABILITY_GROUP.
DropBrokerPriority = 283
DROP_BROKER_PRIORITY.
DropCertificate = 199
DROP_CERTIFICATE.
DropColumnEncryptionKey = 319
DROP_COLUMN_ENCRYPTION_KEY
DropColumnMasterKey = 316
DROP_COLUMN_MASTER_KEY
DropContract = 156
DROP_CONTRACT.
DropCredential = 261
DROP_CREDENTIAL.
DROP_CRYPTOGRAPHIC_PROVIDER.
DropDatabase = 203
DROP_DATABASE.
DropDatabaseAudit = 310
DROP_AUDIT.
DROP_DATABASE_AUDIT_SPECIFICATION.
DROP_DATABASE_ENCRYPTION_KEY.
DropDefault = 231
DROP_DEFAULT.
DropEndpoint = 183
DROP_ENDPOINT.
DROP_EVENT_NOTIFICATION.
DropEventSession = 266
DROP_EVENT_SESSION.
DropExtendedProcedure = 232
DROP_EXTENDED_PROCEDURE.
DropExtendedProperty = 233
DROP_EXTENDED_PROPERTY.
DropExternalLanguage = 331
DROP_EXTERNAL_LANGUAGE
DropExternalLibrary = 326
DROP_EXTERNAL_LIBRARY
DropExternalResourcePool = 323
DROP_EXTERNAL_RESOURCE_POOL
DropFullTextCatalog = 234
DROP_FULLTEXT_CATALOG.
DropFullTextIndex = 235
DROP_FULLTEXT_INDEX.
DropFullTextStopList = 295
DROP_FULLTEXT_STOPLIST.
DropFunction = 63
DROP_FUNCTION.
DropIndex = 26
DROP_INDEX.
DropLinkedServer = 262
DROP_LINKED_SERVER.
DropLinkedServerLogin = 236
DROP_LINKED_SERVER_LOGIN.
DropLogin = 146
DROP_LOGIN.
DropMasterKey = 254
DROP_MASTER_KEY.
DropMessage = 237
DROP_MESSAGE.
DropMessageType = 153
DROP_MESSAGE_TYPE.
DropPartitionFunction = 193
DROP_PARTITION_FUNCTION.
DropPartitionScheme = 196
DROP_PARTITION_SCHEME.
DropPlanGuide = 238
DROP_PLAN_GUIDE.
DropProcedure = 53
DROP_PROCEDURE.
DropQueue = 159
DROP_QUEUE.
DropRemoteServer = 240
DROP_REMOTE_SERVER.
DropRemoteServiceBinding = 176
DROP_REMOTE_SERVICE_BINDING.
DropResourcePool = 269
DROP_RESOURCE_POOL.
DropRole = 136
DROP_ROLE.
DropRoleMember = 208
DROP_ROLE_MEMBER.
DropRoute = 166
DROP_ROUTE.
DropRule = 239
DROP_RULE.
DropSchema = 143
DROP_SCHEMA.
DropSearchPropertyList = 299
DROP_SEARCH_PROPERTY_LIST.
DropSecurityPolicy = 314
DROP SECURITY POLICY
DROP_SENSITIVITY_CLASSIFICATION
DropSequence = 305
DROP_SEQUENCE.
DropServerAudit = 286
DROP_SERVER_AUDIT.
DROP_SERVER_AUDIT_SPECIFICATION.
DropServerRole = 302
DROP_SERVER_ROLE.
DropServerRoleMember = 210
DROP_SERVER_ROLE_MEMBER.
DropService = 163
DROP_SERVICE.
DropSignature = 258
DROP_SIGNATURE.
DROP_SIGNATURE_SCHEMA_OBJECT.
DropStatistics = 29
DROP_STATISTICS.
DropSymmetricKey = 246
DROP_SYMMETRIC_KEY.
DropSynonym = 36
DROP_SYNONYM.
DropTable = 23
DROP_TABLE.
DropTrigger = 73
DROP_TRIGGER.
DropType = 93
DROP_TYPE.
DropUser = 133
DROP_USER.
DropView = 43
DROP_VIEW.
DropWorkloadGroup = 272
DROP_WORKLOAD_GROUP.
DropXmlSchemaCollection = 179
DROP_XML_SCHEMA_COLLECTION.
ErrorLog = 1022
ERRORLOG.
EventLog = 1021
EVENTLOG.
Exception = 1033
EXCEPTION.
ExchangeSpillEvent = 1127
EXCHANGE_SPILL_EVENT.
ExecutionWarnings = 1067
EXECUTION_WARNINGS.
FtCrawlAborted = 1157
FT_CRAWL_ABORTED.
FtCrawlStarted = 1155
FT_CRAWL_STARTED.
FtCrawlStopped = 1156
FT_CRAWL_STOPPED.
GrantDatabase = 170
GRANT_DATABASE.
GrantServer = 167
GRANT_SERVER.
HashWarning = 1055
HASH_WARNING.
LockDeadlock = 1025
LOCK_DEADLOCK.
LockDeadlockChain = 1059
LOCK_DEADLOCK_CHAIN.
LockEscalation = 1060
LOCK_ESCALATION.
LogFileAutoGrow = 1093
LOG_FILE_AUTO_GROW.
LogFileAutoShrink = 1095
LOG_FILE_AUTO_SHRINK.
MissingColumnStatistics = 1079
MISSING_COLUMN_STATISTICS.
MissingJoinPredicate = 1080
MISSING_JOIN_PREDICATE.
MountTape = 1195
MOUNT_TAPE.
ObjectAltered = 1164
OBJECT_ALTERED.
ObjectCreated = 1046
OBJECT_CREATED.
ObjectDeleted = 1047
OBJECT_DELETED.
OledbCallEvent = 1119
OLEDB_CALL_EVENT.
OledbDataReadEvent = 1121
OLEDB_DATAREAD_EVENT.
OledbErrors = 1061
OLEDB_ERRORS.
OledbProviderInformation = 1194
OLEDB_PROVIDER_INFORMATION.
OledbQueryInterfaceEvent = 1120
OLEDB_QUERYINTERFACE_EVENT.
QnDynamics = 1202
QN__DYNAMICS.
QnParameterTable = 1200
QN__PARAMETER_TABLE.
QnSubscription = 1199
QN__SUBSCRIPTION.
QnTemplate = 1201
QN__TEMPLATE.
QueueActivation = 173
QUEUE_ACTIVATION.
Rename = 241
RENAME.
RevokeDatabase = 172
REVOKE_DATABASE.
RevokeServer = 169
REVOKE_SERVER.
ServerMemoryChange = 1081
SERVER_MEMORY_CHANGE.
ShowPlanAllForQueryCompile = 1169
SHOWPLAN_ALL_FOR_QUERY_COMPILE.
ShowPlanXml = 1122
SHOWPLAN_XML.
ShowPlanXmlForQueryCompile = 1168
SHOWPLAN_XML_FOR_QUERY_COMPILE.
ShowPlanXmlStatisticsProfile = 1146
SHOWPLAN_XML_STATISTICS_PROFILE.
SortWarnings = 1069
SORT_WARNINGS.
SpCacheInsert = 1035
SP_CACHEINSERT.
SpCacheMiss = 1034
SP_CACHEMISS.
SpCacheRemove = 1036
SP_CACHEREMOVE.
SpRecompile = 1037
SP_RECOMPILE.
SqlStmtRecompile = 1166
SQL_STMTRECOMPILE.
TraceFileClose = 1150
TRACE_FILE_CLOSE.
UnbindDefault = 242
UNBIND_DEFAULT.
UnbindRule = 243
UNBIND_RULE.
Unknown = 0
Unknown
UpdateStatistics = 28
UPDATE_STATISTICS.
UserConfigurable0 = 1082
USERCONFIGURABLE_0.
UserConfigurable1 = 1083
USERCONFIGURABLE_1.
UserConfigurable2 = 1084
USERCONFIGURABLE_2.
UserConfigurable3 = 1085
USERCONFIGURABLE_3.
UserConfigurable4 = 1086
USERCONFIGURABLE_4.
UserConfigurable5 = 1087
USERCONFIGURABLE_5.
UserConfigurable6 = 1088
USERCONFIGURABLE_6.
UserConfigurable7 = 1089
USERCONFIGURABLE_7.
UserConfigurable8 = 1090
USERCONFIGURABLE_8.
UserConfigurable9 = 1091
USERCONFIGURABLE_9.
UserErrorMessage = 1162
USER_ERROR_MESSAGE.
XQueryStaticType = 1198
XQUERY_STATIC_TYPE.