Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

EventType Enumeration

The EventType enumeration is a list of constant values that specify the various different types of events that are supported by SQL Server.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public enum EventType
Member nameDescription
AddRoleMemberEvent that occurs when a member is added to a database role.
AddServerRoleMemberEvent that occurs when a member is added to a server role.
AddSignatureEvent that occurs when a signature is added.
AddSignatureSchemaObjectEvent that occurs when an AddSignatureSchemaObject is added to a database.
AlterApplicationRoleEvent that occurs when an application role is altered.
AlterAssemblyEvent that occurs when an assembly is altered.
AlterAsymmetricKeyEvent that occurs when an asymmetric key is altered.
AlterAuthorizationDatabaseEvent that occurs when an authorization database is altered.
AlterAuthorizationServerEvent that occurs when an authorization server is altered.
AlterBrokerPriorityEvent that occurs when a broker priority is altered.
AlterCertificateEvent that occurs when a certificate is altered.
AlterCredentialEvent that occurs when a credential is altered.
AlterCryptographicProviderEvent that occurs when a cryptographic provider is altered.
AlterDatabaseEvent that occurs when a database is altered.
AlterDatabaseAuditSpecificationEvent that occurs when a database audit specification is altered.
AlterDatabaseEncryptionKeyEvent that occurs when a .database encryption key is altered.
AlterEndpointEvent that occurs when an HTTP endpoint is altered.
AlterEventSessionEvent that occurs when an event session is altered.
AlterExtendedPropertyEvent that occurs when an extended property is altered.
AlterFulltextCatalogEvent that occurs when a Full-Text catalog is altered.
AlterFulltextIndexEvent that occurs when a Full-Text index is altered.
AlterFulltextStoplistEvent that occurs when a full-text stop list is altered.
AlterFunctionEvent that occurs when a function is altered.
AlterIndexEvent that occurs when an index is altered.
AlterInstanceEvent that occurs when a server instance is altered.
AlterLinkedServerEvent that occurs when a .linked server is altered.
AlterLoginEvent that occurs when a login is altered.
AlterMasterKeyEvent that occurs when a .master key is altered.
AlterMessageEvent that occurs when a .message is altered.
AlterMessageTypeEvent that occurs when a message is altered.
AlterPartitionFunctionEvent that occurs when a partition function is altered.
AlterPartitionSchemeEvent that occurs when a partition scheme is altered.
AlterPlanGuideEvent that occurs when a plan guide is altered.
AlterProcedureEvent that occurs when a stored procedure is altered.
AlterQueueEvent that occurs when a queue is altered.
AlterRemoteServerEvent that occurs when a remote server is altered.
AlterRemoteServiceBindingEvent that occurs when a remote service binding is altered.
AlterResourceGovernorConfigEvent that occurs when the resource governor configuration is altered.
AlterResourcePoolEvent that occurs when a resource pool is altered.
AlterRoleEvent that occurs when a role is altered.
AlterRouteEvent that occurs when a route is altered.
AlterSchemaEvent that occurs when a schema is altered.
AlterServerAuditEvent that occurs when a server audit is altered.
AlterServerAuditSpecificationEvent that occurs when a server audit specification is altered.
AlterServiceEvent that occurs when a service is altered.
AlterServiceMasterKeyEvent that occurs when a .service master key is altered.
AlterSymmetricKey
AlterTableEvent that occurs when a table is altered.
AlterTriggerEvent that occurs when a trigger is altered.
AlterUserEvent that occurs when a user is altered.
AlterViewEvent that occurs when a view is altered.
AlterWorkloadGroupEvent that occurs when a workload group is altered.
AlterXmlSchemaCollectionEvent that occurs when an XML schema collection is altered.
AssemblyLoadEvent that occurs when an assembly is loaded.
AuditAddloginEventEvent that occurs when adding a login is audited.
AuditAddDBUserEventEvent that occurs when adding a database user is audited.
AuditAddLoginToServerRoleEventEvent that occurs when adding a login to a server role is audited.
AuditAddMemberToDBRoleEventEvent that occurs when adding a member to a database role is audited.
AuditAddRoleEventEvent that occurs when adding a role is audited.
AuditAppRoleChangePasswordEventEvent that occurs when changing an application role password is audited.
AuditBackupRestoreEventEvent that occurs when backing up or restoring is audited.
AuditChangeAuditEventEvent that occurs when changing an audit event is audited.
AuditChangeDatabaseOwnerEvent that occurs when changing the database owner is audited.
AuditDatabaseManagementEventEvent that occurs when database management is audited.
AuditDatabaseObjectAccessEventEvent that occurs when accessing a database object is audited.
AuditDatabaseObjectGdrEventEvent that occurs when a database object's GDR is audited.
AuditDatabaseObjectManagementEventEvent that occurs when database object management is audited.
AuditDatabaseObjectTakeOwnershipEventEvent that occurs when taking ownership of a database object is audited.
AuditDatabaseOperationEventEvent that occurs when database operations are audited.
AuditDatabasePrincipalImpersonationEventEvent that occurs when database principal impersonation is audited.
AuditDatabasePrincipalManagementEventEvent that occurs when database principal management is audited.
AuditDatabaseScopeGdrEventEvent that occurs when database scope GDR is audited.
AuditDbccEventEvent that occurs when a database consistency check (DBCC) event is audited.
AuditFulltext
AuditLoginEvent that occurs when a login is audited.
AuditLoginChangePasswordEventEvent that occurs when a login password change is audited.
AuditLoginChangePropertyEventEvent that occurs when a login property change is audited.
AuditLoginFailedEvent that occurs when a failed login attempt is audited.
AuditLoginGdrEventEvent that occurs when a login GDR event is audited.
AuditLogoutEvent that occurs when a log out is audited.
AuditSchemaObjectAccessEventEvent that occurs when access to a schema object is audited.
AuditSchemaObjectGdrEventEvent that occurs when a schema object GDR is audited.
AuditSchemaObjectManagementEventEvent that occurs when schema object management is audited.
AuditSchemaObjectTakeOwnershipEventEvent that occurs when taking ownership of a schema object is audited.
AuditServerAlterTraceEventEvent that occurs when an alter server trace is audited.
AuditServerObjectGdrEventEvent that occurs when a server object GDR is audited.
AuditServerObjectManagementEventEvent that occurs when server object management is audited.
AuditServerObjectTakeOwnershipEventEvent that occurs when taking ownership of the server object is audited.
AuditServerOperationEventEvent that occurs when server operation is audited.
AuditServerPrincipalImpersonationEventEvent that occurs when server principal impersonation is audited.
AuditServerPrincipalManagementEventEvent that occurs when server principal management is audited.
AuditServerScopeGdrEventEvent that occurs when server scope GDR is audited.
BindDefaultEvent that occurs when a default is bound to a column or to an alias data type.
BindRuleEvent that occurs when a rule is bound to a column or to an alias data type.
BitmapWarningCan be used to report when bitmap filters have been disabled in a query.
BlockedProcessReportEvent that occurs when a blocked process is reported.
BrokerQueueDisabledEvent that occurs when a Service Broker queue is disabled.
CpuThresholdExceededEvent that occurs when the CPU threshold has been exceeded.
CreateApplicationRoleEvent that occurs when an application role is created.
CreateAssemblyEvent that occurs when a server assembly is created.
CreateAsymmetricKeyEvent that occurs when an asymmetric key is created.
CreateBrokerPriorityEvent that occurs when a broker priority is created.
CreateCertificateEvent that occurs when a certificate is created.
CreateContractEvent that occurs when a contract is created.
CreateCredentialEvent that occurs when a credential is created.
CreateCryptographicProviderEvent that occurs when cryptographic provider is created.
CreateDatabaseEvent that occurs when a database is created.
CreateDatabaseAuditSpecificationEvent that occurs when a database audit specification is created.
CreateDatabaseEncryptionKeyEvent that occurs when a database encryption key is created.
CreateDefaultCreates an object that is called a default. When bound to a column or an alias data type, a default specifies a value to be inserted into the column to which the object is bound (or into all columns, in the case of an alias data type), when no value is explicitly supplied during an insert.
CreateEndpointEvent that occurs when an endpoint is created.
CreateEventNotificationEvent that occurs when event notification is created.
CreateEventSessionEvent that occurs when an event session is created.
CreateExtendedProcedureEvent that occurs when an extended stored procedure is created.
CreateExtendedPropertyEvent that occurs when an extended property is created.
CreateFulltextCatalogEvent that occurs when a Full-Text catalog is created.
CreateFulltextIndexEvent that occurs when a Full-Text index is created.
CreateFulltextStoplistEvent that occurs when a full-text stop list is created.
CreateFunctionEvent that occurs when a function is created.
CreateIndexEvent that occurs when an index is created.
CreateLinkedServerEvent that occurs when a linked server is created.
CreateLinkedServerLoginEvent that occurs when a linked server login is created.
CreateLoginEvent that occurs when a login is created.
CreateMasterKeyEvent that occurs when a master key is created.
CreateMessageEvent that occurs when a message is created.
CreateMessageTypeEvent that occurs when a message type is created.
CreatePartitionFunctionEvent that occurs when a partition function is created.
CreatePartitionSchemeEvent that occurs when a partition scheme is created.
CreatePlanGuideEvent that occurs when a plan guide is created.
CreateProcedureEvent that occurs when a stored procedure is created.
CreateQueueEvent that occurs when a queue is created.
CreateRemoteServerEvent that occurs when a remote server is created.
CreateRemoteServiceBindingEvent that occurs when a remote service binding is created.
CreateResourcePoolEvent that occurs when a resource pool is created.
CreateRoleEvent that occurs when a role is created.
CreateRouteEvent that occurs when a route is created.
CreateRuleEvent that occurs when a rule is created.
CreateSchemaEvent that occurs when a schema is created.
CreateServerAudit
CreateServerAuditSpecificationEvent that occurs when a server audit specification is created.
CreateServiceEvent that occurs when a service is created.
CreateSpatialIndexEvent that occurs when a spatial index is created.
CreateStatisticsEvent that occurs when a statistics counter is created.
CreateSymmetricKeyEvent that occurs when a symmetric key is created.
CreateSynonymEvent that occurs when a synonym is created.
CreateTableEvent that occurs when a table is created.
CreateTriggerEvent that occurs when a trigger is created.
CreateTypeEvent that occurs when a type is created.
CreateUserEvent that occurs when a user is created.
CreateViewEvent that occurs when a view is created.
CreateWorkloadGroupEvent that occurs when a workload group is created.
CreateXmlIndexEvent that occurs when an XML index is created.
CreateXmlSchemaCollectionEvent that occurs when an XML schema collection is created.
DatabaseMirroringStateChangeEvent that occurs when the mirroring state of a database changes.
DatabaseSuspectDataPageEvent that occurs when a suspect data page is detected in the database.
DataFileAutoGrowEvent that occurs when a data file grows automatically.
DataFileAutoShrinkEvent that occurs when a data file shrinks automatically.
DeadlockGraphEvent that occurs when a deadlock graph occurs.
DenyDatabaseEvent that occurs when a database denies access.
DenyServerEvent that occurs when a server denies access.
DeprecationAnnouncementEvent that occurs when a deprecation announcement is issued.
DeprecationFinalSupportEvent that occurs when a deprecation final support message is issued.
DropApplicationRoleEvent that occurs when an application role is dropped.
DropAssemblyEvent that occurs when an assembly is dropped.
DropAsymmetricKeyEvent that occurs when an asymmetric key is dropped.
DropBrokerPriorityEvent that occurs when a broker priority is dropped.
DropCertificateEvent that occurs when a certificate is dropped.
DropContractEvent that occurs when a contract is dropped.
DropCredentialEvent that occurs when a credential is dropped.
DropCryptographicProviderEvent that occurs when a cryptographic provider is dropped.
DropDatabaseEvent that occurs when a database is dropped.
DropDatabaseAuditSpecificationEvent that occurs when a database audit specification is dropped.
DropDatabaseEncryptionKeyEvent that occurs when a database encryption key is dropped.
DropDefaultDrops an object called a default. When bound to a column or an alias data type, a default specifies a value to be inserted into the column to which the object is bound (or into all columns, in the case of an alias data type), when no value is explicitly supplied during an insert.
DropEndpointEvent that occurs when an HTTP endpoint is dropped.
DropEventNotificationEvent that occurs when an event notification is dropped.
DropEventSessionEvent that occurs when an event session is dropped.
DropExtendedProcedureEvent that occurs when an extended procedure is dropped.
DropExtendedPropertyEvent that occurs when an extended property is dropped.
DropFulltextCatalogEvent that occurs when a Full-Text catalog is dropped.
DropFulltextIndexEvent that occurs when a Full-Text index is dropped.
DropFulltextStoplistEvent that occurs when a full-text stop list is dropped.
DropFunctionEvent that occurs when a function is dropped.
DropIndexEvent that occurs when an index is dropped.
DropLinkedServerEvent that occurs when a linked server is dropped.
DropLinkedServerLoginEvent that occurs when a linked server login is dropped.
DropLoginEvent that occurs when a login is dropped.
DropMasterKeyEvent that occurs when a master key is dropped..
DropMessageEvent that occurs when a message is dropped.
DropMessageTypeEvent that occurs when a message is dropped.
DropPartitionFunctionEvent that occurs when a partition function is dropped.
DropPartitionSchemeEvent that occurs when a partition scheme is dropped.
DropPlanGuideEvent that occurs when a plan guide is dropped.
DropProcedureEvent that occurs when a procedure is dropped.
DropQueueEvent that occurs when a queue is dropped.
DropRemoteServerEvent that occurs when a remote server is dropped..
DropRemoteServiceBindingEvent that occurs when a remote service binding is dropped.
DropResourcePoolEvent that occurs when a resource pool is dropped.
DropRoleEvent that occurs when a role is dropped.
DropRoleMemberEvent that occurs when a member of a role is dropped.
DropRouteEvent that occurs when a route is dropped.
DropRuleEvent that occurs when a rule is dropped.
DropSchemaEvent that occurs when a schema is dropped.
DropServerAudit
DropServerAuditSpecificationEvent that occurs when a server audit specification is dropped.
DropServerRoleMemberEvent that occurs when a member of a server role is dropped.
DropServiceEvent that occurs when a service is dropped.
DropSignatureEvent that occurs when a signature is dropped.
DropSignatureSchemaObjectEvent that occurs when a signature schema object is dropped.
DropStatisticsEvent that occurs when a statistics counter is dropped.
DropSymmetricKeyEvent that occurs when a symmetric key is dropped.
DropSynonymEvent that occurs when a synonym is dropped.
DropTableEvent that occurs when a table is dropped.
DropTriggerEvent that occurs when a trigger is dropped.
DropTypeEvent that occurs when a type is dropped.
DropUserEvent that occurs when a user is dropped.
DropViewEvent that occurs when a view is dropped.
DropWorkloadGroupEvent that occurs when a workload group is dropped.
DropXmlSchemaCollectionEvent that occurs when an XML schema collection is dropped.
ErrorlogEvent that occurs when an error is logged.
EventlogEvent that occurs when an event is logged.
ExceptionEvent that occurs when an exception occurs.
ExchangeSpillEventEvent that occurs when an exchange spill event occurs.
ExecutionWarningsEvent that occurs when an execution warning occurs.
FtCrawlAbortedEvent that occurs when a Full-Text crawl is stopped.
FtCrawlStartedEvent that occurs when an FT crawl is started.
FtCrawlStoppedEvent that occurs when an FT crawl is stopped.
GrantDatabaseEvent that occurs when access is granted to a database.
GrantServerEvent that occurs when access to a server is granted.
HashWarningEvent that occurs when a hash warning occurs.
LockDeadlockEvent that occurs when a deadlock occurs.
LockDeadlockChainEvent that occurs when a deadlock chain occurs.
LockEscalationEvent that occurs when lock escalation occurs.
LogFileAutoGrowEvent that occurs when the log file automatically grows.
LogFileAutoShrinkEvent that occurs when log file is automatically shrinked.
MissingColumnStatisticsEvent that occurs when missing columns statistics are discovered.
MissingJoinPredicateEvent that occurs when a missing join predicate occurs.
MountTapeEvent that occurs when tape is mounted.
ObjectAlteredEvent that occurs when an object is altered.
ObjectCreatedEvent that occurs when an object is created.
ObjectDeletedEvent that occurs when an object is deleted.
OledbCallEventEvent that occurs when an OLE DB call event occurs.
OledbDatareadEventEvent that occurs when an OLE DB data is read.
OledbErrorsEvent that occurs when OLE DB errors occur.
OledbProviderInformationEvent that occurs when OLE DB provider information is accessed.
OledbQueryinterfaceEventEvent that occurs when an OLE DB interface is queried.
Qn_dynamicsEvent that occurs when a dynamics event occurs.
Qn_parameterTableEvent that occurs when a parameter table event occurs.
Qn_subscriptionEvent that occurs when a subscription event occurs.
Qn_templateEvent that occurs when a template event occurs.
QueueActivationEvent that occurs when a queue is activated.
Rename
RevokeDatabaseEvent that occurs when access to a database is revoked.
RevokeServerEvent that occurs when access to a server is revoked.
ServerMemoryChangeEvent that occurs when a change to the server memory is made.
ShowplanAllForQueryCompileEvent that occurs when a Showplan All For Query Compile request occurs.
ShowplanXmlEvent that occurs when a Showplan XML request occurs.
ShowplanXmlForQueryCompileEvent that occurs when a Showplan XML For Query Compile request occurs.
ShowplanXmlStatisticsProfileEvent that occurs when a Showplan XML statistics profile request occurs.
SortWarningsEvent that occurs when a warning message is generated during a sort operation.
SpCacheinsertEvent that occurs when a stored procedure cache insert occurs.
SpCachemissEvent that occurs when a stored procedure cache miss occurs.
SpCacheremoveEvent that occurs when a stored procedure cache remove occurs.
SpRecompileEvent that occurs when a stored procedure is recompiled.
SqlStmtrecompileEvent that occurs when a Transact-SQL statement is recompiled.
TraceFileCloseEvent that occurs when a trace file is closed.
UnbindDefaultEvent that occurs when a default is unbound.
UnbindRuleEvent that occurs when a rule is unbound.
UpdateStatisticsEvent that occurs when statistics are updated.
Userconfigurable0A user-configurable event.
Userconfigurable1A user-configurable event.
Userconfigurable2A user-configurable event.
Userconfigurable3A user-configurable event.
Userconfigurable4A user-configurable event.
Userconfigurable5A user-configurable event.
Userconfigurable6A user-configurable event.
Userconfigurable7A user-configurable event.
Userconfigurable8A user-configurable event.
Userconfigurable9A user-configurable event.
UserErrorMessageEvent that occurs when a user error message is issued.
XqueryStaticTypeEvent that occurs when an Xquery static type event occurs.

The EventType enumeration class is served by the EventType class.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.