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)

Syntax

'Declaration
Public Enumeration EventType
'Usage
Dim instance As EventType
public enum EventType
public enum class EventType
type EventType
public enum EventType

Members

Member name Description
AddRoleMember Event that occurs when a member is added to a database role.
AddServerRoleMember Event that occurs when a member is added to a server role.
AddSignature Event that occurs when a signature is added.
AddSignatureSchemaObject Event that occurs when an AddSignatureSchemaObject is added to a database.
AlterApplicationRole Event that occurs when an application role is altered.
AlterAssembly Event that occurs when an assembly is altered.
AlterAsymmetricKey Event that occurs when an asymmetric key is altered.
AlterAuthorizationDatabase Event that occurs when an authorization database is altered.
AlterAuthorizationServer Event that occurs when an authorization server is altered.
AlterBrokerPriority Event that occurs when a broker priority is altered.
AlterCertificate Event that occurs when a certificate is altered.
AlterCredential Event that occurs when a credential is altered.
AlterCryptographicProvider Event that occurs when a cryptographic provider is altered.
AlterDatabase Event that occurs when a database is altered.
AlterDatabaseAuditSpecification Event that occurs when a database audit specification is altered.
AlterDatabaseEncryptionKey Event that occurs when a .database encryption key is altered.
AlterEndpoint Event that occurs when an HTTP endpoint is altered.
AlterEventSession Event that occurs when an event session is altered.
AlterExtendedProperty Event that occurs when an extended property is altered.
AlterFulltextCatalog Event that occurs when a Full-Text catalog is altered.
AlterFulltextIndex Event that occurs when a Full-Text index is altered.
AlterFulltextStoplist Event that occurs when a full-text stop list is altered.
AlterFunction Event that occurs when a function is altered.
AlterIndex Event that occurs when an index is altered.
AlterInstance Event that occurs when a server instance is altered.
AlterLinkedServer Event that occurs when a .linked server is altered.
AlterLogin Event that occurs when a login is altered.
AlterMasterKey Event that occurs when a .master key is altered.
AlterMessage Event that occurs when a .message is altered.
AlterMessageType Event that occurs when a message is altered.
AlterPartitionFunction Event that occurs when a partition function is altered.
AlterPartitionScheme Event that occurs when a partition scheme is altered.
AlterPlanGuide Event that occurs when a plan guide is altered.
AlterProcedure Event that occurs when a stored procedure is altered.
AlterQueue Event that occurs when a queue is altered.
AlterRemoteServer Event that occurs when a remote server is altered.
AlterRemoteServiceBinding Event that occurs when a remote service binding is altered.
AlterResourceGovernorConfig Event that occurs when the resource governor configuration is altered.
AlterResourcePool Event that occurs when a resource pool is altered.
AlterRole Event that occurs when a role is altered.
AlterRoute Event that occurs when a route is altered.
AlterSchema Event that occurs when a schema is altered.
AlterServerAudit Event that occurs when a server audit is altered.
AlterServerAuditSpecification Event that occurs when a server audit specification is altered.
AlterService Event that occurs when a service is altered.
AlterServiceMasterKey Event that occurs when a .service master key is altered.
AlterSymmetricKey
AlterTable Event that occurs when a table is altered.
AlterTrigger Event that occurs when a trigger is altered.
AlterUser Event that occurs when a user is altered.
AlterView Event that occurs when a view is altered.
AlterWorkloadGroup Event that occurs when a workload group is altered.
AlterXmlSchemaCollection Event that occurs when an XML schema collection is altered.
AssemblyLoad Event that occurs when an assembly is loaded.
AuditAddloginEvent Event that occurs when adding a login is audited.
AuditAddDBUserEvent Event that occurs when adding a database user is audited.
AuditAddLoginToServerRoleEvent Event that occurs when adding a login to a server role is audited.
AuditAddMemberToDBRoleEvent Event that occurs when adding a member to a database role is audited.
AuditAddRoleEvent Event that occurs when adding a role is audited.
AuditAppRoleChangePasswordEvent Event that occurs when changing an application role password is audited.
AuditBackupRestoreEvent Event that occurs when backing up or restoring is audited.
AuditChangeAuditEvent Event that occurs when changing an audit event is audited.
AuditChangeDatabaseOwner Event that occurs when changing the database owner is audited.
AuditDatabaseManagementEvent Event that occurs when database management is audited.
AuditDatabaseObjectAccessEvent Event that occurs when accessing a database object is audited.
AuditDatabaseObjectGdrEvent Event that occurs when a database object's GDR is audited.
AuditDatabaseObjectManagementEvent Event that occurs when database object management is audited.
AuditDatabaseObjectTakeOwnershipEvent Event that occurs when taking ownership of a database object is audited.
AuditDatabaseOperationEvent Event that occurs when database operations are audited.
AuditDatabasePrincipalImpersonationEvent Event that occurs when database principal impersonation is audited.
AuditDatabasePrincipalManagementEvent Event that occurs when database principal management is audited.
AuditDatabaseScopeGdrEvent Event that occurs when database scope GDR is audited.
AuditDbccEvent Event that occurs when a database consistency check (DBCC) event is audited.
AuditFulltext
AuditLogin Event that occurs when a login is audited.
AuditLoginChangePasswordEvent Event that occurs when a login password change is audited.
AuditLoginChangePropertyEvent Event that occurs when a login property change is audited.
AuditLoginFailed Event that occurs when a failed login attempt is audited.
AuditLoginGdrEvent Event that occurs when a login GDR event is audited.
AuditLogout Event that occurs when a log out is audited.
AuditSchemaObjectAccessEvent Event that occurs when access to a schema object is audited.
AuditSchemaObjectGdrEvent Event that occurs when a schema object GDR is audited.
AuditSchemaObjectManagementEvent Event that occurs when schema object management is audited.
AuditSchemaObjectTakeOwnershipEvent Event that occurs when taking ownership of a schema object is audited.
AuditServerAlterTraceEvent Event that occurs when an alter server trace is audited.
AuditServerObjectGdrEvent Event that occurs when a server object GDR is audited.
AuditServerObjectManagementEvent Event that occurs when server object management is audited.
AuditServerObjectTakeOwnershipEvent Event that occurs when taking ownership of the server object is audited.
AuditServerOperationEvent Event that occurs when server operation is audited.
AuditServerPrincipalImpersonationEvent Event that occurs when server principal impersonation is audited.
AuditServerPrincipalManagementEvent Event that occurs when server principal management is audited.
AuditServerScopeGdrEvent Event that occurs when server scope GDR is audited.
BindDefault Event that occurs when a default is bound to a column or to an alias data type.
BindRule Event that occurs when a rule is bound to a column or to an alias data type.
BitmapWarning Can be used to report when bitmap filters have been disabled in a query.
BlockedProcessReport Event that occurs when a blocked process is reported.
BrokerQueueDisabled Event that occurs when a Service Broker queue is disabled.
CpuThresholdExceeded Event that occurs when the CPU threshold has been exceeded.
CreateApplicationRole Event that occurs when an application role is created.
CreateAssembly Event that occurs when a server assembly is created.
CreateAsymmetricKey Event that occurs when an asymmetric key is created.
CreateBrokerPriority Event that occurs when a broker priority is created.
CreateCertificate Event that occurs when a certificate is created.
CreateContract Event that occurs when a contract is created.
CreateCredential Event that occurs when a credential is created.
CreateCryptographicProvider Event that occurs when cryptographic provider is created.
CreateDatabase Event that occurs when a database is created.
CreateDatabaseAuditSpecification Event that occurs when a database audit specification is created.
CreateDatabaseEncryptionKey Event that occurs when a database encryption key is created.
CreateDefault Creates 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.
CreateEndpoint Event that occurs when an endpoint is created.
CreateEventNotification Event that occurs when event notification is created.
CreateEventSession Event that occurs when an event session is created.
CreateExtendedProcedure Event that occurs when an extended stored procedure is created.
CreateExtendedProperty Event that occurs when an extended property is created.
CreateFulltextCatalog Event that occurs when a Full-Text catalog is created.
CreateFulltextIndex Event that occurs when a Full-Text index is created.
CreateFulltextStoplist Event that occurs when a full-text stop list is created.
CreateFunction Event that occurs when a function is created.
CreateIndex Event that occurs when an index is created.
CreateLinkedServer Event that occurs when a linked server is created.
CreateLinkedServerLogin Event that occurs when a linked server login is created.
CreateLogin Event that occurs when a login is created.
CreateMasterKey Event that occurs when a master key is created.
CreateMessage Event that occurs when a message is created.
CreateMessageType Event that occurs when a message type is created.
CreatePartitionFunction Event that occurs when a partition function is created.
CreatePartitionScheme Event that occurs when a partition scheme is created.
CreatePlanGuide Event that occurs when a plan guide is created.
CreateProcedure Event that occurs when a stored procedure is created.
CreateQueue Event that occurs when a queue is created.
CreateRemoteServer Event that occurs when a remote server is created.
CreateRemoteServiceBinding Event that occurs when a remote service binding is created.
CreateResourcePool Event that occurs when a resource pool is created.
CreateRole Event that occurs when a role is created.
CreateRoute Event that occurs when a route is created.
CreateRule Event that occurs when a rule is created.
CreateSchema Event that occurs when a schema is created.
CreateServerAudit
CreateServerAuditSpecification Event that occurs when a server audit specification is created.
CreateService Event that occurs when a service is created.
CreateSpatialIndex Event that occurs when a spatial index is created.
CreateStatistics Event that occurs when a statistics counter is created.
CreateSymmetricKey Event that occurs when a symmetric key is created.
CreateSynonym Event that occurs when a synonym is created.
CreateTable Event that occurs when a table is created.
CreateTrigger Event that occurs when a trigger is created.
CreateType Event that occurs when a type is created.
CreateUser Event that occurs when a user is created.
CreateView Event that occurs when a view is created.
CreateWorkloadGroup Event that occurs when a workload group is created.
CreateXmlIndex Event that occurs when an XML index is created.
CreateXmlSchemaCollection Event that occurs when an XML schema collection is created.
DatabaseMirroringStateChange Event that occurs when the mirroring state of a database changes.
DatabaseSuspectDataPage Event that occurs when a suspect data page is detected in the database.
DataFileAutoGrow Event that occurs when a data file grows automatically.
DataFileAutoShrink Event that occurs when a data file shrinks automatically.
DeadlockGraph Event that occurs when a deadlock graph occurs.
DenyDatabase Event that occurs when a database denies access.
DenyServer Event that occurs when a server denies access.
DeprecationAnnouncement Event that occurs when a deprecation announcement is issued.
DeprecationFinalSupport Event that occurs when a deprecation final support message is issued.
DropApplicationRole Event that occurs when an application role is dropped.
DropAssembly Event that occurs when an assembly is dropped.
DropAsymmetricKey Event that occurs when an asymmetric key is dropped.
DropBrokerPriority Event that occurs when a broker priority is dropped.
DropCertificate Event that occurs when a certificate is dropped.
DropContract Event that occurs when a contract is dropped.
DropCredential Event that occurs when a credential is dropped.
DropCryptographicProvider Event that occurs when a cryptographic provider is dropped.
DropDatabase Event that occurs when a database is dropped.
DropDatabaseAuditSpecification Event that occurs when a database audit specification is dropped.
DropDatabaseEncryptionKey Event that occurs when a database encryption key is dropped.
DropDefault Drops 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.
DropEndpoint Event that occurs when an HTTP endpoint is dropped.
DropEventNotification Event that occurs when an event notification is dropped.
DropEventSession Event that occurs when an event session is dropped.
DropExtendedProcedure Event that occurs when an extended procedure is dropped.
DropExtendedProperty Event that occurs when an extended property is dropped.
DropFulltextCatalog Event that occurs when a Full-Text catalog is dropped.
DropFulltextIndex Event that occurs when a Full-Text index is dropped.
DropFulltextStoplist Event that occurs when a full-text stop list is dropped.
DropFunction Event that occurs when a function is dropped.
DropIndex Event that occurs when an index is dropped.
DropLinkedServer Event that occurs when a linked server is dropped.
DropLinkedServerLogin Event that occurs when a linked server login is dropped.
DropLogin Event that occurs when a login is dropped.
DropMasterKey Event that occurs when a master key is dropped..
DropMessage Event that occurs when a message is dropped.
DropMessageType Event that occurs when a message is dropped.
DropPartitionFunction Event that occurs when a partition function is dropped.
DropPartitionScheme Event that occurs when a partition scheme is dropped.
DropPlanGuide Event that occurs when a plan guide is dropped.
DropProcedure Event that occurs when a procedure is dropped.
DropQueue Event that occurs when a queue is dropped.
DropRemoteServer Event that occurs when a remote server is dropped..
DropRemoteServiceBinding Event that occurs when a remote service binding is dropped.
DropResourcePool Event that occurs when a resource pool is dropped.
DropRole Event that occurs when a role is dropped.
DropRoleMember Event that occurs when a member of a role is dropped.
DropRoute Event that occurs when a route is dropped.
DropRule Event that occurs when a rule is dropped.
DropSchema Event that occurs when a schema is dropped.
DropServerAudit
DropServerAuditSpecification Event that occurs when a server audit specification is dropped.
DropServerRoleMember Event that occurs when a member of a server role is dropped.
DropService Event that occurs when a service is dropped.
DropSignature Event that occurs when a signature is dropped.
DropSignatureSchemaObject Event that occurs when a signature schema object is dropped.
DropStatistics Event that occurs when a statistics counter is dropped.
DropSymmetricKey Event that occurs when a symmetric key is dropped.
DropSynonym Event that occurs when a synonym is dropped.
DropTable Event that occurs when a table is dropped.
DropTrigger Event that occurs when a trigger is dropped.
DropType Event that occurs when a type is dropped.
DropUser Event that occurs when a user is dropped.
DropView Event that occurs when a view is dropped.
DropWorkloadGroup Event that occurs when a workload group is dropped.
DropXmlSchemaCollection Event that occurs when an XML schema collection is dropped.
Errorlog Event that occurs when an error is logged.
Eventlog Event that occurs when an event is logged.
Exception Event that occurs when an exception occurs.
ExchangeSpillEvent Event that occurs when an exchange spill event occurs.
ExecutionWarnings Event that occurs when an execution warning occurs.
FtCrawlAborted Event that occurs when a Full-Text crawl is stopped.
FtCrawlStarted Event that occurs when an FT crawl is started.
FtCrawlStopped Event that occurs when an FT crawl is stopped.
GrantDatabase Event that occurs when access is granted to a database.
GrantServer Event that occurs when access to a server is granted.
HashWarning Event that occurs when a hash warning occurs.
LockDeadlock Event that occurs when a deadlock occurs.
LockDeadlockChain Event that occurs when a deadlock chain occurs.
LockEscalation Event that occurs when lock escalation occurs.
LogFileAutoGrow Event that occurs when the log file automatically grows.
LogFileAutoShrink Event that occurs when log file is automatically shrinked.
MissingColumnStatistics Event that occurs when missing columns statistics are discovered.
MissingJoinPredicate Event that occurs when a missing join predicate occurs.
MountTape Event that occurs when tape is mounted.
ObjectAltered Event that occurs when an object is altered.
ObjectCreated Event that occurs when an object is created.
ObjectDeleted Event that occurs when an object is deleted.
OledbCallEvent Event that occurs when an OLE DB call event occurs.
OledbDatareadEvent Event that occurs when an OLE DB data is read.
OledbErrors Event that occurs when OLE DB errors occur.
OledbProviderInformation Event that occurs when OLE DB provider information is accessed.
OledbQueryinterfaceEvent Event that occurs when an OLE DB interface is queried.
Qn_dynamics Event that occurs when a dynamics event occurs.
Qn_parameterTable Event that occurs when a parameter table event occurs.
Qn_subscription Event that occurs when a subscription event occurs.
Qn_template Event that occurs when a template event occurs.
QueueActivation Event that occurs when a queue is activated.
Rename
RevokeDatabase Event that occurs when access to a database is revoked.
RevokeServer Event that occurs when access to a server is revoked.
ServerMemoryChange Event that occurs when a change to the server memory is made.
ShowplanAllForQueryCompile Event that occurs when a Showplan All For Query Compile request occurs.
ShowplanXml Event that occurs when a Showplan XML request occurs.
ShowplanXmlForQueryCompile Event that occurs when a Showplan XML For Query Compile request occurs.
ShowplanXmlStatisticsProfile Event that occurs when a Showplan XML statistics profile request occurs.
SortWarnings Event that occurs when a warning message is generated during a sort operation.
SpCacheinsert Event that occurs when a stored procedure cache insert occurs.
SpCachemiss Event that occurs when a stored procedure cache miss occurs.
SpCacheremove Event that occurs when a stored procedure cache remove occurs.
SpRecompile Event that occurs when a stored procedure is recompiled.
SqlStmtrecompile Event that occurs when a Transact-SQL statement is recompiled.
TraceFileClose Event that occurs when a trace file is closed.
UnbindDefault Event that occurs when a default is unbound.
UnbindRule Event that occurs when a rule is unbound.
UpdateStatistics Event that occurs when statistics are updated.
Userconfigurable0 A user-configurable event.
Userconfigurable1 A user-configurable event.
Userconfigurable2 A user-configurable event.
Userconfigurable3 A user-configurable event.
Userconfigurable4 A user-configurable event.
Userconfigurable5 A user-configurable event.
Userconfigurable6 A user-configurable event.
Userconfigurable7 A user-configurable event.
Userconfigurable8 A user-configurable event.
Userconfigurable9 A user-configurable event.
UserErrorMessage Event that occurs when a user error message is issued.
XqueryStaticType Event that occurs when an Xquery static type event occurs.

Remarks

The EventType enumeration class is served by the EventType class.