EventType Enumeration
Updated: April 20, 2017
Sql Server event types
Assembly: Microsoft.SqlServer.Dac.Extensions (in Microsoft.SqlServer.Dac.Extensions.dll)
| Member name | Description | |
|---|---|---|
| AddRoleMember | AddRoleMember | |
| AddServerRoleMember | AddServerRoleMember | |
| AddSignature | AddSignature | |
| AddSignatureSchemaObject | AddSignatureSchemaObject | |
| AlterApplicationRole | AlterApplicationRole | |
| AlterAssembly | AlterAssembly | |
| AlterAsymmetricKey | AlterAsymmetricKey | |
| AlterAuthorizationDatabase | AlterAuthorizationDatabase | |
| AlterAuthorizationServer | AlterAuthorizationServer | |
| AlterAvailabilityGroup | AlterAvailabilityGroup | |
| AlterBrokerPriority | AlterBrokerPriority | |
| AlterCertificate | AlterCertificate | |
| AlterColumnEncryptionKey | ||
| AlterCredential | AlterCredential | |
| AlterCryptographicProvider | AlterCryptographicProvider | |
| AlterDatabase | AlterDatabase | |
| AlterDatabaseAudit | AlterDatabaseAudit | |
| AlterDatabaseAuditSpecification | AlterDatabaseAuditSpecification | |
| AlterDatabaseEncryptionKey | AlterDatabaseEncryptionKey | |
| AlterDatabaseScopedConfiguration | ||
| AlterEndpoint | AlterEndpoint | |
| AlterEventSession | AlterEventSession | |
| AlterExtendedProperty | AlterExtendedProperty | |
| AlterExternalLibrary | ||
| AlterExternalResourcePool | ||
| AlterFullTextCatalog | AlterFullTextCatalog | |
| AlterFullTextIndex | AlterFullTextIndex | |
| AlterFullTextStopList | AlterFullTextStopList | |
| AlterFunction | AlterFunction | |
| AlterIndex | AlterIndex | |
| AlterInstance | AlterInstance | |
| AlterLinkedServer | AlterLinkedServer | |
| AlterLogin | AlterLogin | |
| AlterMasterKey | AlterMasterKey | |
| AlterMessage | AlterMessage | |
| AlterMessageType | AlterMessageType | |
| AlterPartitionFunction | AlterPartitionFunction | |
| AlterPartitionScheme | AlterPartitionScheme | |
| AlterPlanGuide | AlterPlanGuide | |
| AlterProcedure | AlterProcedure | |
| AlterQueue | AlterQueue | |
| AlterRemoteServer | AlterRemoteServer | |
| AlterRemoteServiceBinding | AlterRemoteServiceBinding | |
| AlterResourceGovernorConfig | AlterResourceGovernorConfig | |
| AlterResourcePool | AlterResourcePool | |
| AlterRole | AlterRole | |
| AlterRoute | AlterRoute | |
| AlterSchema | AlterSchema | |
| AlterSearchPropertyList | AlterSearchPropertyList | |
| AlterSecurityPolicy | ||
| AlterSequence | AlterSequence | |
| AlterServerAudit | AlterServerAudit | |
| AlterServerAuditSpecification | AlterServerAuditSpecification | |
| AlterServerConfiguration | AlterServerConfiguration | |
| AlterServerRole | AlterServerRole | |
| AlterService | AlterService | |
| AlterServiceMasterKey | AlterServiceMasterKey | |
| AlterSymmetricKey | AlterSymmetricKey | |
| AlterTable | AlterTable | |
| AlterTrigger | AlterTrigger | |
| AlterUser | AlterUser | |
| AlterView | AlterView | |
| AlterWorkloadGroup | AlterWorkloadGroup | |
| AlterXmlSchemaCollection | AlterXmlSchemaCollection | |
| AssemblyLoad | AssemblyLoad | |
| AuditAddDbUserEvent | AuditAddDbUserEvent | |
| AuditAddLoginEvent | AuditAddLoginEvent | |
| AuditAddLoginToServerRoleEvent | AuditAddLoginToServerRoleEvent | |
| AuditAddMemberToDbRoleEvent | AuditAddMemberToDbRoleEvent | |
| AuditAddRoleEvent | AuditAddRoleEvent | |
| AuditAppRoleChangePasswordEvent | AuditAppRoleChangePasswordEvent | |
| AuditBackupRestoreEvent | AuditBackupRestoreEvent | |
| AuditChangeAuditEvent | AuditChangeAuditEvent | |
| AuditChangeDatabaseOwner | AuditChangeDatabaseOwner | |
| AuditDatabaseManagementEvent | AuditDatabaseManagementEvent | |
| AuditDatabaseObjectAccessEvent | AuditDatabaseObjectAccessEvent | |
| AuditDatabaseObjectGdrEvent | AuditDatabaseObjectGdrEvent | |
| AuditDatabaseObjectManagementEvent | AuditDatabaseObjectManagementEvent | |
| AuditDatabaseObjectTakeOwnershipEvent | AuditDatabaseObjectTakeOwnershipEvent | |
| AuditDatabaseOperationEvent | AuditDatabaseOperationEvent | |
| AuditDatabasePrincipalImpersonationEvent | AuditDatabasePrincipalImpersonationEvent | |
| AuditDatabasePrincipalManagementEvent | AuditDatabasePrincipalManagementEvent | |
| AuditDatabaseScopeGdrEvent | AuditDatabaseScopeGdrEvent | |
| AuditDbccEvent | AuditDbccEvent | |
| AuditFullText | AuditFullText | |
| AuditLogin | AuditLogin | |
| AuditLoginChangePasswordEvent | AuditLoginChangePasswordEvent | |
| AuditLoginChangePropertyEvent | AuditLoginChangePropertyEvent | |
| AuditLoginFailed | AuditLoginFailed | |
| AuditLoginGdrEvent | AuditLoginGdrEvent | |
| AuditLogout | AuditLogout | |
| AuditSchemaObjectAccessEvent | AuditSchemaObjectAccessEvent | |
| AuditSchemaObjectGdrEvent | AuditSchemaObjectGdrEvent | |
| AuditSchemaObjectManagementEvent | AuditSchemaObjectManagementEvent | |
| AuditSchemaObjectTakeOwnershipEvent | AuditSchemaObjectTakeOwnershipEvent | |
| AuditServerAlterTraceEvent | AuditServerAlterTraceEvent | |
| AuditServerObjectGdrEvent | AuditServerObjectGdrEvent | |
| AuditServerObjectManagementEvent | AuditServerObjectManagementEvent | |
| AuditServerObjectTakeOwnershipEvent | AuditServerObjectTakeOwnershipEvent | |
| AuditServerOperationEvent | AuditServerOperationEvent | |
| AuditServerPrincipalImpersonationEvent | AuditServerPrincipalImpersonationEvent | |
| AuditServerPrincipalManagementEvent | AuditServerPrincipalManagementEvent | |
| AuditServerScopeGdrEvent | AuditServerScopeGdrEvent | |
| BindDefault | BindDefault | |
| BindRule | BindRule | |
| BitmapWarning | BitmapWarning | |
| BlockedProcessReport | BlockedProcessReport | |
| BrokerQueueDisabled | BrokerQueueDisabled | |
| CpuThresholdExceeded | CpuThresholdExceeded | |
| CreateApplicationRole | CreateApplicationRole | |
| CreateAssembly | CreateAssembly | |
| CreateAsymmetricKey | CreateAsymmetricKey | |
| CreateAvailabilityGroup | CreateAvailabilityGroup | |
| CreateBrokerPriority | CreateBrokerPriority | |
| CreateCertificate | CreateCertificate | |
| CreateColumnEncryptionKey | ||
| CreateColumnMasterKey | ||
| CreateContract | CreateContract | |
| CreateCredential | CreateCredential | |
| CreateCryptographicProvider | CreateCryptographicProvider | |
| CreateDatabase | CreateDatabase | |
| CreateDatabaseAudit | CreateDatabaseAudit | |
| CreateDatabaseAuditSpecification | CreateDatabaseAuditSpecification | |
| CreateDatabaseEncryptionKey | CreateDatabaseEncryptionKey | |
| CreateDefault | CreateDefault | |
| CreateEndpoint | CreateEndpoint | |
| CreateEventNotification | CreateEventNotification | |
| CreateEventSession | CreateEventSession | |
| CreateExtendedProcedure | CreateExtendedProcedure | |
| CreateExtendedProperty | CreateExtendedProperty | |
| CreateExternalLibrary | ||
| CreateExternalResourcePool | ||
| CreateFullTextCatalog | CreateFullTextCatalog | |
| CreateFullTextIndex | CreateFullTextIndex | |
| CreateFullTextStopList | CreateFullTextStopList | |
| CreateFunction | CreateFunction | |
| CreateIndex | CreateIndex | |
| CreateLinkedServer | CreateLinkedServer | |
| CreateLinkedServerLogin | CreateLinkedServerLogin | |
| CreateLogin | CreateLogin | |
| CreateMasterKey | CreateMasterKey | |
| CreateMessage | CreateMessage | |
| CreateMessageType | CreateMessageType | |
| CreatePartitionFunction | CreatePartitionFunction | |
| CreatePartitionScheme | CreatePartitionScheme | |
| CreatePlanGuide | CreatePlanGuide | |
| CreateProcedure | CreateProcedure | |
| CreateQueue | CreateQueue | |
| CreateRemoteServer | CreateRemoteServer | |
| CreateRemoteServiceBinding | CreateRemoteServiceBinding | |
| CreateResourcePool | CreateResourcePool | |
| CreateRole | CreateRole | |
| CreateRoute | CreateRoute | |
| CreateRule | CreateRule | |
| CreateSchema | CreateSchema | |
| CreateSearchPropertyList | CreateSearchPropertyList | |
| CreateSecurityPolicy | ||
| CreateSequence | CreateSequence | |
| CreateServerAudit | CreateServerAudit | |
| CreateServerAuditSpecification | CreateServerAuditSpecification | |
| CreateServerRole | CreateServerRole | |
| CreateService | CreateService | |
| CreateSpatialIndex | CreateSpatialIndex | |
| CreateStatistics | CreateStatistics | |
| CreateSymmetricKey | CreateSymmetricKey | |
| CreateSynonym | CreateSynonym | |
| CreateTable | CreateTable | |
| CreateTrigger | CreateTrigger | |
| CreateType | CreateType | |
| CreateUser | CreateUser | |
| CreateView | CreateView | |
| CreateWorkloadGroup | CreateWorkloadGroup | |
| CreateXmlIndex | CreateXmlIndex | |
| CreateXmlSchemaCollection | CreateXmlSchemaCollection | |
| DatabaseMirroringStateChange | DatabaseMirroringStateChange | |
| DatabaseSuspectDataPage | DatabaseSuspectDataPage | |
| DataFileAutoGrow | DataFileAutoGrow | |
| DataFileAutoShrink | DataFileAutoShrink | |
| DeadlockGraph | DeadlockGraph | |
| DenyDatabase | DenyDatabase | |
| DenyServer | DenyServer | |
| DeprecationAnnouncement | DeprecationAnnouncement | |
| DeprecationFinalSupport | DeprecationFinalSupport | |
| DropApplicationRole | DropApplicationRole | |
| DropAssembly | DropAssembly | |
| DropAsymmetricKey | DropAsymmetricKey | |
| DropAvailabilityGroup | DropAvailabilityGroup | |
| DropBrokerPriority | DropBrokerPriority | |
| DropCertificate | DropCertificate | |
| DropColumnEncryptionKey | ||
| DropColumnMasterKey | ||
| DropContract | DropContract | |
| DropCredential | DropCredential | |
| DropCryptographicProvider | DropCryptographicProvider | |
| DropDatabase | DropDatabase | |
| DropDatabaseAudit | DropDatabaseAudit | |
| DropDatabaseAuditSpecification | DropDatabaseAuditSpecification | |
| DropDatabaseEncryptionKey | DropDatabaseEncryptionKey | |
| DropDefault | DropDefault | |
| DropEndpoint | DropEndpoint | |
| DropEventNotification | DropEventNotification | |
| DropEventSession | DropEventSession | |
| DropExtendedProcedure | DropExtendedProcedure | |
| DropExtendedProperty | DropExtendedProperty | |
| DropExternalLibrary | ||
| DropExternalResourcePool | ||
| DropFullTextCatalog | DropFullTextCatalog | |
| DropFullTextIndex | DropFullTextIndex | |
| DropFullTextStopList | DropFullTextStopList | |
| DropFunction | DropFunction | |
| DropIndex | DropIndex | |
| DropLinkedServer | DropLinkedServer | |
| DropLinkedServerLogin | DropLinkedServerLogin | |
| DropLogin | DropLogin | |
| DropMasterKey | DropMasterKey | |
| DropMessage | DropMessage | |
| DropMessageType | DropMessageType | |
| DropPartitionFunction | DropPartitionFunction | |
| DropPartitionScheme | DropPartitionScheme | |
| DropPlanGuide | DropPlanGuide | |
| DropProcedure | DropProcedure | |
| DropQueue | DropQueue | |
| DropRemoteServer | DropRemoteServer | |
| DropRemoteServiceBinding | DropRemoteServiceBinding | |
| DropResourcePool | DropResourcePool | |
| DropRole | DropRole | |
| DropRoleMember | DropRoleMember | |
| DropRoute | DropRoute | |
| DropRule | DropRule | |
| DropSchema | DropSchema | |
| DropSearchPropertyList | DropSearchPropertyList | |
| DropSecurityPolicy | ||
| DropSequence | DropSequence | |
| DropServerAudit | DropServerAudit | |
| DropServerAuditSpecification | DropServerAuditSpecification | |
| DropServerRole | DropServerRole | |
| DropServerRoleMember | DropServerRoleMember | |
| DropService | DropService | |
| DropSignature | DropSignature | |
| DropSignatureSchemaObject | DropSignatureSchemaObject | |
| DropStatistics | DropStatistics | |
| DropSymmetricKey | DropSymmetricKey | |
| DropSynonym | DropSynonym | |
| DropTable | DropTable | |
| DropTrigger | DropTrigger | |
| DropType | DropType | |
| DropUser | DropUser | |
| DropView | DropView | |
| DropWorkloadGroup | DropWorkloadGroup | |
| DropXmlSchemaCollection | DropXmlSchemaCollection | |
| ErrorLog | ErrorLog | |
| EventLog | EventLog | |
| Exception | Exception | |
| ExchangeSpillEvent | ExchangeSpillEvent | |
| ExecutionWarnings | ExecutionWarnings | |
| FtCrawlAborted | FtCrawlAborted | |
| FtCrawlStarted | FtCrawlStarted | |
| FtCrawlStopped | FtCrawlStopped | |
| GrantDatabase | GrantDatabase | |
| GrantServer | GrantServer | |
| HashWarning | HashWarning | |
| LockDeadlock | LockDeadlock | |
| LockDeadlockChain | LockDeadlockChain | |
| LockEscalation | LockEscalation | |
| LogFileAutoGrow | LogFileAutoGrow | |
| LogFileAutoShrink | LogFileAutoShrink | |
| MissingColumnStatistics | MissingColumnStatistics | |
| MissingJoinPredicate | MissingJoinPredicate | |
| MountTape | MountTape | |
| ObjectAltered | ObjectAltered | |
| ObjectCreated | ObjectCreated | |
| ObjectDeleted | ObjectDeleted | |
| OledbCallEvent | OledbCallEvent | |
| OledbDataReadEvent | OledbDataReadEvent | |
| OledbErrors | OledbErrors | |
| OledbProviderInformation | OledbProviderInformation | |
| OledbQueryInterfaceEvent | OledbQueryInterfaceEvent | |
| QnDynamics | QnDynamics | |
| QnParameterTable | QnParameterTable | |
| QnSubscription | QnSubscription | |
| QnTemplate | QnTemplate | |
| QueueActivation | QueueActivation | |
| Rename | Rename | |
| RevokeDatabase | RevokeDatabase | |
| RevokeServer | RevokeServer | |
| ServerMemoryChange | ServerMemoryChange | |
| ShowPlanAllForQueryCompile | ShowPlanAllForQueryCompile | |
| ShowPlanXml | ShowPlanXml | |
| ShowPlanXmlForQueryCompile | ShowPlanXmlForQueryCompile | |
| ShowPlanXmlStatisticsProfile | ShowPlanXmlStatisticsProfile | |
| SortWarnings | SortWarnings | |
| SpCacheInsert | SpCacheInsert | |
| SpCacheMiss | SpCacheMiss | |
| SpCacheRemove | SpCacheRemove | |
| SpRecompile | SpRecompile | |
| SqlStmtRecompile | SqlStmtRecompile | |
| TraceFileClose | TraceFileClose | |
| UnbindDefault | UnbindDefault | |
| UnbindRule | UnbindRule | |
| Unknown | Unknown | |
| UpdateStatistics | UpdateStatistics | |
| UserConfigurable0 | UserConfigurable0 | |
| UserConfigurable1 | UserConfigurable1 | |
| UserConfigurable2 | UserConfigurable2 | |
| UserConfigurable3 | UserConfigurable3 | |
| UserConfigurable4 | UserConfigurable4 | |
| UserConfigurable5 | UserConfigurable5 | |
| UserConfigurable6 | UserConfigurable6 | |
| UserConfigurable7 | UserConfigurable7 | |
| UserConfigurable8 | UserConfigurable8 | |
| UserConfigurable9 | UserConfigurable9 | |
| UserErrorMessage | UserErrorMessage | |
| XQueryStaticType | XQueryStaticType |