Share via


EventNotificationEventType Enum

Definition

Possible event types

public enum EventNotificationEventType
type EventNotificationEventType = 
Public Enum EventNotificationEventType
Inheritance
EventNotificationEventType

Fields

Name Value Description
Unknown 0

Unknown

CreateTable 21

CREATE_TABLE.

AlterTable 22

ALTER_TABLE.

DropTable 23

DROP_TABLE.

CreateIndex 24

CREATE_INDEX.

AlterIndex 25

ALTER_INDEX.

DropIndex 26

DROP_INDEX.

CreateStatistics 27

CREATE_STATISTICS.

UpdateStatistics 28

UPDATE_STATISTICS.

DropStatistics 29

DROP_STATISTICS.

CreateSynonym 34

CREATE_SYNONYM.

DropSynonym 36

DROP_SYNONYM.

CreateView 41

CREATE_VIEW.

AlterView 42

ALTER_VIEW.

DropView 43

DROP_VIEW.

CreateProcedure 51

CREATE_PROCEDURE.

AlterProcedure 52

ALTER_PROCEDURE.

DropProcedure 53

DROP_PROCEDURE.

CreateFunction 61

CREATE_FUNCTION.

AlterFunction 62

ALTER_FUNCTION.

DropFunction 63

DROP_FUNCTION.

CreateTrigger 71

CREATE_TRIGGER.

AlterTrigger 72

ALTER_TRIGGER.

DropTrigger 73

DROP_TRIGGER.

CreateEventNotification 74

CREATE_EVENT_NOTIFICATION.

DropEventNotification 76

DROP_EVENT_NOTIFICATION.

CreateType 91

CREATE_TYPE.

DropType 93

DROP_TYPE.

CreateAssembly 101

CREATE_ASSEMBLY.

AlterAssembly 102

ALTER_ASSEMBLY.

DropAssembly 103

DROP_ASSEMBLY.

CreateUser 131

CREATE_USER.

AlterUser 132

ALTER_USER.

DropUser 133

DROP_USER.

CreateRole 134

CREATE_ROLE.

AlterRole 135

ALTER_ROLE.

DropRole 136

DROP_ROLE.

CreateApplicationRole 137

CREATE_APPLICATION_ROLE.

AlterApplicationRole 138

ALTER_APPLICATION_ROLE.

DropApplicationRole 139

DROP_APPLICATION_ROLE.

CreateSchema 141

CREATE_SCHEMA.

AlterSchema 142

ALTER_SCHEMA.

DropSchema 143

DROP_SCHEMA.

CreateLogin 144

CREATE_LOGIN.

AlterLogin 145

ALTER_LOGIN.

DropLogin 146

DROP_LOGIN.

CreateMessageType 151

CREATE_MESSAGE_TYPE.

AlterMessageType 152

ALTER_MESSAGE_TYPE.

DropMessageType 153

DROP_MESSAGE_TYPE.

CreateContract 154

CREATE_CONTRACT.

DropContract 156

DROP_CONTRACT.

CreateQueue 157

CREATE_QUEUE.

AlterQueue 158

ALTER_QUEUE.

DropQueue 159

DROP_QUEUE.

BrokerQueueDisabled 160

BROKER_QUEUE_DISABLED.

CreateService 161

CREATE_SERVICE.

AlterService 162

ALTER_SERVICE.

DropService 163

DROP_SERVICE.

CreateRoute 164

CREATE_ROUTE.

AlterRoute 165

ALTER_ROUTE.

DropRoute 166

DROP_ROUTE.

GrantServer 167

GRANT_SERVER.

DenyServer 168

DENY_SERVER.

RevokeServer 169

REVOKE_SERVER.

GrantDatabase 170

GRANT_DATABASE.

DenyDatabase 171

DENY_DATABASE.

RevokeDatabase 172

REVOKE_DATABASE.

QueueActivation 173

QUEUE_ACTIVATION.

CreateRemoteServiceBinding 174

CREATE_REMOTE_SERVICE_BINDING.

AlterRemoteServiceBinding 175

ALTER_REMOTE_SERVICE_BINDING.

DropRemoteServiceBinding 176

DROP_REMOTE_SERVICE_BINDING.

CreateXmlSchemaCollection 177

CREATE_XML_SCHEMA_COLLECTION.

AlterXmlSchemaCollection 178

ALTER_XML_SCHEMA_COLLECTION.

DropXmlSchemaCollection 179

DROP_XML_SCHEMA_COLLECTION.

CreateEndpoint 181

CREATE_ENDPOINT.

AlterEndpoint 182

ALTER_ENDPOINT.

DropEndpoint 183

DROP_ENDPOINT.

CreatePartitionFunction 191

CREATE_PARTITION_FUNCTION.

AlterPartitionFunction 192

ALTER_PARTITION_FUNCTION.

DropPartitionFunction 193

DROP_PARTITION_FUNCTION.

CreatePartitionScheme 194

CREATE_PARTITION_SCHEME.

AlterPartitionScheme 195

ALTER_PARTITION_SCHEME.

DropPartitionScheme 196

DROP_PARTITION_SCHEME.

CreateCertificate 197

CREATE_CERTIFICATE.

AlterCertificate 198

ALTER_CERTIFICATE.

DropCertificate 199

DROP_CERTIFICATE.

CreateDatabase 201

CREATE_DATABASE.

AlterDatabase 202

ALTER_DATABASE.

DropDatabase 203

DROP_DATABASE.

AlterAuthorizationServer 204

ALTER_AUTHORIZATION_SERVER.

AlterAuthorizationDatabase 205

ALTER_AUTHORIZATION_DATABASE.

CreateXmlIndex 206

CREATE_XML_INDEX.

AddRoleMember 207

ADD_ROLE_MEMBER.

DropRoleMember 208

DROP_ROLE_MEMBER.

AddServerRoleMember 209

ADD_SERVER_ROLE_MEMBER.

DropServerRoleMember 210

DROP_SERVER_ROLE_MEMBER.

AlterExtendedProperty 211

ALTER_EXTENDED_PROPERTY.

AlterFullTextCatalog 212

ALTER_FULLTEXT_CATALOG.

AlterFullTextIndex 213

ALTER_FULLTEXT_INDEX.

AlterInstance 214

ALTER_INSTANCE.

AlterMessage 215

ALTER_MESSAGE.

AlterPlanGuide 216

ALTER_PLAN_GUIDE.

AlterRemoteServer 217

ALTER_REMOTE_SERVER.

BindDefault 218

BIND_DEFAULT.

BindRule 219

BIND_RULE.

CreateDefault 220

CREATE_DEFAULT.

CreateExtendedProcedure 221

CREATE_EXTENDED_PROCEDURE.

CreateExtendedProperty 222

CREATE_EXTENDED_PROPERTY.

CreateFullTextCatalog 223

CREATE_FULLTEXT_CATALOG.

CreateFullTextIndex 224

CREATE_FULLTEXT_INDEX.

CreateLinkedServer 225

CREATE_LINKED_SERVER.

CreateLinkedServerLogin 226

CREATE_LINKED_SERVER_LOGIN.

CreateMessage 227

CREATE_MESSAGE.

CreatePlanGuide 228

CREATE_PLAN_GUIDE.

CreateRule 229

CREATE_RULE.

CreateRemoteServer 230

CREATE_REMOTE_SERVER.

DropDefault 231

DROP_DEFAULT.

DropExtendedProcedure 232

DROP_EXTENDED_PROCEDURE.

DropExtendedProperty 233

DROP_EXTENDED_PROPERTY.

DropFullTextCatalog 234

DROP_FULLTEXT_CATALOG.

DropFullTextIndex 235

DROP_FULLTEXT_INDEX.

DropLinkedServerLogin 236

DROP_LINKED_SERVER_LOGIN.

DropMessage 237

DROP_MESSAGE.

DropPlanGuide 238

DROP_PLAN_GUIDE.

DropRule 239

DROP_RULE.

DropRemoteServer 240

DROP_REMOTE_SERVER.

Rename 241

RENAME.

UnbindDefault 242

UNBIND_DEFAULT.

UnbindRule 243

UNBIND_RULE.

CreateSymmetricKey 244

CREATE_SYMMETRIC_KEY.

AlterSymmetricKey 245

ALTER_SYMMETRIC_KEY.

DropSymmetricKey 246

DROP_SYMMETRIC_KEY.

CreateAsymmetricKey 247

CREATE_ASYMMETRIC_KEY.

AlterAsymmetricKey 248

ALTER_ASYMMETRIC_KEY.

DropAsymmetricKey 249

DROP_ASYMMETRIC_KEY.

AlterServiceMasterKey 251

ALTER_SERVICE_MASTER_KEY.

CreateMasterKey 252

CREATE_MASTER_KEY.

AlterMasterKey 253

ALTER_MASTER_KEY.

DropMasterKey 254

DROP_MASTER_KEY.

AddSignatureSchemaObject 255

ADD_SIGNATURE_SCHEMA_OBJECT.

DropSignatureSchemaObject 256

DROP_SIGNATURE_SCHEMA_OBJECT.

AddSignature 257

ADD_SIGNATURE.

DropSignature 258

DROP_SIGNATURE.

CreateCredential 259

CREATE_CREDENTIAL.

AlterCredential 260

ALTER_CREDENTIAL.

DropCredential 261

DROP_CREDENTIAL.

DropLinkedServer 262

DROP_LINKED_SERVER.

AlterLinkedServer 263

ALTER_LINKED_SERVER.

CreateEventSession 264

CREATE_EVENT_SESSION.

AlterEventSession 265

ALTER_EVENT_SESSION.

DropEventSession 266

DROP_EVENT_SESSION.

CreateResourcePool 267

CREATE_RESOURCE_POOL.

AlterResourcePool 268

ALTER_RESOURCE_POOL.

DropResourcePool 269

DROP_RESOURCE_POOL.

CreateWorkloadGroup 270

CREATE_WORKLOAD_GROUP.

AlterWorkloadGroup 271

ALTER_WORKLOAD_GROUP.

DropWorkloadGroup 272

DROP_WORKLOAD_GROUP.

AlterResourceGovernorConfig 273

ALTER_RESOURCE_GOVERNOR_CONFIG.

CreateSpatialIndex 274

CREATE_SPATIAL_INDEX.

CreateCryptographicProvider 275

CREATE_CRYPTOGRAPHIC_PROVIDER.

AlterCryptographicProvider 276

ALTER_CRYPTOGRAPHIC_PROVIDER.

DropCryptographicProvider 277

DROP_CRYPTOGRAPHIC_PROVIDER.

CreateDatabaseEncryptionKey 278

CREATE_DATABASE_ENCRYPTION_KEY.

AlterDatabaseEncryptionKey 279

ALTER_DATABASE_ENCRYPTION_KEY.

DropDatabaseEncryptionKey 280

DROP_DATABASE_ENCRYPTION_KEY.

CreateBrokerPriority 281

CREATE_BROKER_PRIORITY.

AlterBrokerPriority 282

ALTER_BROKER_PRIORITY.

DropBrokerPriority 283

DROP_BROKER_PRIORITY.

CreateServerAudit 284

CREATE_SERVER_AUDIT.

AlterServerAudit 285

ALTER_SERVER_AUDIT.

DropServerAudit 286

DROP_SERVER_AUDIT.

CreateServerAuditSpecification 287

CREATE_SERVER_AUDIT_SPECIFICATION.

AlterServerAuditSpecification 288

ALTER_SERVER_AUDIT_SPECIFICATION.

DropServerAuditSpecification 289

DROP_SERVER_AUDIT_SPECIFICATION.

CreateDatabaseAuditSpecification 290

CREATE_DATABASE_AUDIT_SPECIFICATION.

AlterDatabaseAuditSpecification 291

ALTER_DATABASE_AUDIT_SPECIFICATION.

DropDatabaseAuditSpecification 292

DROP_DATABASE_AUDIT_SPECIFICATION.

CreateFullTextStopList 293

CREATE_FULLTEXT_STOPLIST.

AlterFullTextStopList 294

ALTER_FULLTEXT_STOPLIST.

DropFullTextStopList 295

DROP_FULLTEXT_STOPLIST.

AlterServerConfiguration 296

ALTER_SERVER_CONFIGURATION.

CreateSearchPropertyList 297

CREATE_SEARCH_PROPERTY_LIST.

AlterSearchPropertyList 298

ALTER_SEARCH_PROPERTY_LIST.

DropSearchPropertyList 299

DROP_SEARCH_PROPERTY_LIST.

CreateServerRole 300

CREATE_SERVER_ROLE.

AlterServerRole 301

ALTER_SERVER_ROLE.

DropServerRole 302

DROP_SERVER_ROLE.

CreateSequence 303

CREATE_SEQUENCE.

AlterSequence 304

ALTER_SEQUENCE.

DropSequence 305

DROP_SEQUENCE.

CreateAvailabilityGroup 306

CREATE_AVAILABILITY_GROUP.

AlterAvailabilityGroup 307

ALTER_AVAILABILITY_GROUP.

DropAvailabilityGroup 308

DROP_AVAILABILITY_GROUP.

CreateDatabaseAudit 309

CREATE_AUDIT.

DropDatabaseAudit 310

DROP_AUDIT.

AlterDatabaseAudit 311

ALTER_AUDIT.

CreateSecurityPolicy 312

CREATE SECURITY POLICY

AlterSecurityPolicy 313

ALTER SECURITY POLICY

DropSecurityPolicy 314

DROP SECURITY POLICY

CreateColumnMasterKey 315

CREATE_COLUMN_MASTER_KEY

DropColumnMasterKey 316

DROP_COLUMN_MASTER_KEY

CreateColumnEncryptionKey 317

CREATE_COLUMN_ENCRYPTION_KEY

AlterColumnEncryptionKey 318

ALTER_COLUMN_ENCRYPTION_KEY

DropColumnEncryptionKey 319

DROP_COLUMN_ENCRYPTION_KEY

AlterDatabaseScopedConfiguration 320

ALTER_DATABASE_SCOPED_CONFIGURATION

CreateExternalResourcePool 321

CREATE_EXTERNAL_RESOURCE_POOL

AlterExternalResourcePool 322

ALTER_EXTERNAL_RESOURCE_POOL

DropExternalResourcePool 323

DROP_EXTERNAL_RESOURCE_POOL

CreateExternalLibrary 324

CREATE_EXTERNAL_LIBRARY

AlterExternalLibrary 325

ALTER_EXTERNAL_LIBRARY

DropExternalLibrary 326

DROP_EXTERNAL_LIBRARY

AddSensitivityClassification 327

ADD_SENSITIVITY_CLASSIFICATION

DropSensitivityClassification 328

DROP_SENSITIVITY_CLASSIFICATION

CreateExternalLanguage 329

CREATE_EXTERNAL_LANGUAGE

AlterExternalLanguage 330

ALTER_EXTERNAL_LANGUAGE

DropExternalLanguage 331

DROP_EXTERNAL_LANGUAGE

AuditLogin 1014

AUDIT_LOGIN.

AuditLogout 1015

AUDIT_LOGOUT.

AuditLoginFailed 1020

AUDIT_LOGIN_FAILED.

EventLog 1021

EVENTLOG.

ErrorLog 1022

ERRORLOG.

LockDeadlock 1025

LOCK_DEADLOCK.

Exception 1033

EXCEPTION.

SpCacheMiss 1034

SP_CACHEMISS.

SpCacheInsert 1035

SP_CACHEINSERT.

SpCacheRemove 1036

SP_CACHEREMOVE.

SpRecompile 1037

SP_RECOMPILE.

ObjectCreated 1046

OBJECT_CREATED.

ObjectDeleted 1047

OBJECT_DELETED.

HashWarning 1055

HASH_WARNING.

LockDeadlockChain 1059

LOCK_DEADLOCK_CHAIN.

LockEscalation 1060

LOCK_ESCALATION.

OledbErrors 1061

OLEDB_ERRORS.

ExecutionWarnings 1067

EXECUTION_WARNINGS.

SortWarnings 1069

SORT_WARNINGS.

MissingColumnStatistics 1079

MISSING_COLUMN_STATISTICS.

MissingJoinPredicate 1080

MISSING_JOIN_PREDICATE.

ServerMemoryChange 1081

SERVER_MEMORY_CHANGE.

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.

DataFileAutoGrow 1092

DATA_FILE_AUTO_GROW.

LogFileAutoGrow 1093

LOG_FILE_AUTO_GROW.

DataFileAutoShrink 1094

DATA_FILE_AUTO_SHRINK.

LogFileAutoShrink 1095

LOG_FILE_AUTO_SHRINK.

AuditDatabaseScopeGdrEvent 1102

AUDIT_DATABASE_SCOPE_GDR_EVENT.

AuditSchemaObjectGdrEvent 1103

AUDIT_SCHEMA_OBJECT_GDR_EVENT.

AuditAddLoginEvent 1104

AUDIT_ADDLOGIN_EVENT.

AuditLoginGdrEvent 1105

AUDIT_LOGIN_GDR_EVENT.

AuditLoginChangePropertyEvent 1106

AUDIT_LOGIN_CHANGE_PROPERTY_EVENT.

AuditLoginChangePasswordEvent 1107

AUDIT_LOGIN_CHANGE_PASSWORD_EVENT.

AuditAddLoginToServerRoleEvent 1108

AUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENT.

AuditAddDBUserEvent 1109

AUDIT_ADD_DB_USER_EVENT.

AuditAddMemberToDBRoleEvent 1110

AUDIT_ADD_MEMBER_TO_DB_ROLE_EVENT.

AuditAddRoleEvent 1111

AUDIT_ADD_ROLE_EVENT.

AuditAppRoleChangePasswordEvent 1112

AUDIT_APP_ROLE_CHANGE_PASSWORD_EVENT.

AuditSchemaObjectAccessEvent 1114

AUDIT_SCHEMA_OBJECT_ACCESS_EVENT.

AuditBackupRestoreEvent 1115

AUDIT_BACKUP_RESTORE_EVENT.

AuditDbccEvent 1116

AUDIT_DBCC_EVENT.

AuditChangeAuditEvent 1117

AUDIT_CHANGE_AUDIT_EVENT.

OledbCallEvent 1119

OLEDB_CALL_EVENT.

OledbQueryInterfaceEvent 1120

OLEDB_QUERYINTERFACE_EVENT.

OledbDataReadEvent 1121

OLEDB_DATAREAD_EVENT.

ShowPlanXml 1122

SHOWPLAN_XML.

DeprecationAnnouncement 1125

DEPRECATION_ANNOUNCEMENT.

DeprecationFinalSupport 1126

DEPRECATION_FINAL_SUPPORT.

ExchangeSpillEvent 1127

EXCHANGE_SPILL_EVENT.

AuditDatabaseManagementEvent 1128

AUDIT_DATABASE_MANAGEMENT_EVENT.

AuditDatabaseObjectManagementEvent 1129

AUDIT_DATABASE_OBJECT_MANAGEMENT_EVENT.

AuditDatabasePrincipalManagementEvent 1130

AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT.

AuditSchemaObjectManagementEvent 1131

AUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT.

AuditServerPrincipalImpersonationEvent 1132

AUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENT.

AuditDatabasePrincipalImpersonationEvent 1133

AUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENT.

AuditServerObjectTakeOwnershipEvent 1134

AUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENT.

AuditDatabaseObjectTakeOwnershipEvent 1135

AUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENT.

BlockedProcessReport 1137

BLOCKED_PROCESS_REPORT.

ShowPlanXmlStatisticsProfile 1146

SHOWPLAN_XML_STATISTICS_PROFILE.

DeadlockGraph 1148

DEADLOCK_GRAPH.

TraceFileClose 1150

TRACE_FILE_CLOSE.

AuditChangeDatabaseOwner 1152

AUDIT_CHANGE_DATABASE_OWNER.

AuditSchemaObjectTakeOwnershipEvent 1153

AUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENT.

FtCrawlStarted 1155

FT_CRAWL_STARTED.

FtCrawlStopped 1156

FT_CRAWL_STOPPED.

FtCrawlAborted 1157

FT_CRAWL_ABORTED.

UserErrorMessage 1162

USER_ERROR_MESSAGE.

ObjectAltered 1164

OBJECT_ALTERED.

SqlStmtRecompile 1166

SQL_STMTRECOMPILE.

DatabaseMirroringStateChange 1167

DATABASE_MIRRORING_STATE_CHANGE.

ShowPlanXmlForQueryCompile 1168

SHOWPLAN_XML_FOR_QUERY_COMPILE.

ShowPlanAllForQueryCompile 1169

SHOWPLAN_ALL_FOR_QUERY_COMPILE.

AuditServerScopeGdrEvent 1170

AUDIT_SERVER_SCOPE_GDR_EVENT.

AuditServerObjectGdrEvent 1171

AUDIT_SERVER_OBJECT_GDR_EVENT.

AuditDatabaseObjectGdrEvent 1172

AUDIT_DATABASE_OBJECT_GDR_EVENT.

AuditServerOperationEvent 1173

AUDIT_SERVER_OPERATION_EVENT.

AuditServerAlterTraceEvent 1175

AUDIT_SERVER_ALTER_TRACE_EVENT.

AuditServerObjectManagementEvent 1176

AUDIT_SERVER_OBJECT_MANAGEMENT_EVENT.

AuditServerPrincipalManagementEvent 1177

AUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT.

AuditDatabaseOperationEvent 1178

AUDIT_DATABASE_OPERATION_EVENT.

AuditDatabaseObjectAccessEvent 1180

AUDIT_DATABASE_OBJECT_ACCESS_EVENT.

OledbProviderInformation 1194

OLEDB_PROVIDER_INFORMATION.

MountTape 1195

MOUNT_TAPE.

AssemblyLoad 1196

ASSEMBLY_LOAD.

XQueryStaticType 1198

XQUERY_STATIC_TYPE.

QnSubscription 1199

QN__SUBSCRIPTION.

QnParameterTable 1200

QN__PARAMETER_TABLE.

QnTemplate 1201

QN__TEMPLATE.

QnDynamics 1202

QN__DYNAMICS.

BitmapWarning 1212

BITMAP_WARNING.

DatabaseSuspectDataPage 1213

DATABASE_SUSPECT_DATA_PAGE.

CpuThresholdExceeded 1214

CPU_THRESHOLD_EXCEEDED.

AuditFullText 1235

AUDIT_FULLTEXT.

Applies to