Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

EventType Enumeration

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

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
public enum EventType
public enum EventType
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.
AlterApplicationRoleEvent that occurs when an application role is altered.
AlterAssemblyEvent that occurs when an assembly is altered.
AlterAuthorizationDatabaseEvent that occurs when an authorization database is altered.
AlterAuthorizationServerEvent that occurs when an authorization server is altered.
AlterCertificateEvent that occurs when a certificate is altered.
AlterDatabaseEvent that occurs when a database is altered.
AlterEndpointEvent that occurs when an HTTP endpoint is altered.
AlterFunctionEvent that occurs when a function is altered.
AlterIndexEvent that occurs when an index is altered.
AlterLoginEvent that occurs when a login 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.
AlterProcedureEvent that occurs when a stored procedure is altered.
AlterQueueEvent that occurs when a queue is altered.
AlterRemoteServiceBindingEvent that occurs when a remote service binding 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.
AlterServiceEvent that occurs when a service is altered.
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.
AlterXmlSchemaCollectionEvent that occurs when an XML schema collection is altered.
AssemblyLoadEvent that occurs when an assembly is loaded.
AuditAddDBUserEventEvent that occurs when adding a database user is audited.
AuditAddloginEventEvent that occurs when adding a login 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.
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.
BlockedProcessReportEvent that occurs when a blocked process is reported.
BrokerQueueDisabledEvent that occurs when a Service Broker queue is disabled.
CreateApplicationRoleEvent that occurs when an application role is created.
CreateAssemblyEvent that occurs when a server assembly is created.
CreateCertificateEvent that occurs when a certificate is created.
CreateContractEvent that occurs when a contract is created.
CreateDatabaseEvent that occurs when a database is created.
CreateEndpointEvent that occurs when an endpoint is created.
CreateEventNotificationEvent that occurs when event notification is created.
CreateFunctionEvent that occurs when a function is created.
CreateIndexEvent that occurs when an index is created.
CreateLoginEvent that occurs when a login 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.
CreateProcedureEvent that occurs when a stored procedure is created.
CreateQueueEvent that occurs when a queue is created.
CreateRemoteServiceBindingEvent that occurs when a remote service binding is created.
CreateRoleEvent that occurs when a role is created.
CreateRouteEvent that occurs when a route is created.
CreateSchemaEvent that occurs when a schema is created.
CreateServiceEvent that occurs when a service is created.
CreateStatisticsEvent that occurs when a statistics counter 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.
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.
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.
DropCertificateEvent that occurs when a certificate is dropped.
DropContractEvent that occurs when a contract is dropped.
DropDatabaseEvent that occurs when a database is dropped.
DropEndpointEvent that occurs when an HTTP endpoint is dropped.
DropEventNotificationEvent that occurs when an event notification is dropped.
DropFunctionEvent that occurs when a function is dropped.
DropIndexEvent that occurs when an index is dropped.
DropLoginEvent that occurs when a login 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.
DropProcedureEvent that occurs when a procedure is dropped.
DropQueueEvent that occurs when a queue is dropped.
DropRemoteServiceBindingEvent that occurs when a remote service binding 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.
DropSchemaEvent that occurs when a schema is dropped.
DropServerRoleMemberEvent that occurs when a member of a server role is dropped.
DropServiceEvent that occurs when a service is dropped.
DropStatisticsEvent that occurs when a statistics counter 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.
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 an FT 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.
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.
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.

Updated text:

The EventType enumeration class is served by the EventType class.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.


Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Release

History

New content:
  • Modified the description of SortWarnings type.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.