EventType Enumeration

 

Specifies 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)

type EventType

Member nameDescription
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.

AlterAudit

Event that occurs when an audit is altered.

AlterAuthorizationDatabase

Event that occurs when an authorization database is altered.

AlterAuthorizationServer

Event that occurs when an authorization server is altered.

AlterAvailabilityGroup

Event that occurs when the availability group is altered.

AlterBrokerPriority

Event that occurs when a broker priority is altered.

AlterCertificate

Event that occurs when a certificate is altered.

AlterColumnEncryptionKey

Event that occurs when a column encryption key 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.

AlterSearchPropertyList

Event that occurs when a search property list is altered.

AlterSecurityPolicy

Event that occurs when a security policy is altered.

AlterSequence

Event that occurs when a sequence is altered.

AlterServerAudit

Event that occurs when a server audit is altered.

AlterServerAuditSpecification

Event that occurs when a server audit specification is altered.

AlterServerConfiguration

Event that occurs when a server configuration is altered.

AlterServerRole

Event that occurs when a server role is altered.

AlterService

Event that occurs when a service is altered.

AlterServiceMasterKey

Event that occurs when a service master key is altered.

AlterSymmetricKey

Event that occurs when a symmetric key is altered.

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.

AuditAddDBUserEvent

Event that occurs when adding a database user is audited.

AuditAddloginEvent

Event that occurs when adding a login 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

Event that occurs when a Full-Text audit is performed.

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.

CreateAudit

Event that occurs when an audit is created.

CreateAvailabilityGroup

Event that occurs when the availability group is created.

CreateBrokerPriority

Event that occurs when a broker priority is created.

CreateCertificate

Event that occurs when a certificate is created.

CreateColumnEncryptionKey

Event that occurs when a column encryption key is created.

CreateColumnMasterKey

Event that occurs when a column master key 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.

CreateSearchPropertyList

Event that occurs when a search property list is created.

CreateSecurityPolicy

Event that occurs when a security policy is created.

CreateSequence

Event that occurs when a sequence is created.

CreateServerAudit

Event that occurs when a server audit is created.

CreateServerAuditSpecification

Event that occurs when a server audit specification is created.

CreateServerRole

Event that occurs when a server role 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.

DropAudit

Event that occurs when an audit is dropped.

DropAvailabilityGroup

Event that occurs when the availability group is dropped.

DropBrokerPriority

Event that occurs when a broker priority is dropped.

DropCertificate

Event that occurs when a certificate is dropped.

DropColumnEncryptionKey

Event that occurs when a column encryption key is dropped.

DropColumnMasterKey

Event that occurs when a column master key 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.

DropSearchPropertyList

Event that occurs when a search property list is dropped.

DropSecurityPolicy

Event that occurs when security policy is dropped.

DropSequence

Event that occurs when a sequence is dropped.

DropServerAudit

Event that occurs when a server audit is dropped.

DropServerAuditSpecification

Event that occurs when a server audit specification is dropped.

DropServerRole

Event that occurs when a server role 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

Event that occurs when a user related object in the database is renamed.

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.

The EventType enumeration class is served by the EventType class.

Return to top
Show: