EventType 열거형
The EventType enumeration is a list of constant values that specify the various different types of events that are supported by SQL Server.
네임스페이스: Microsoft.SqlServer.Management.Smo
어셈블리: Microsoft.SqlServer.Smo(Microsoft.SqlServer.Smo.dll)
구문
‘선언
Public Enumeration EventType
‘사용 방법
Dim instance As EventType
public enum EventType
public enum class EventType
type EventType
public enum EventType
멤버
| 멤버 이름 | 설명 | |
|---|---|---|
| 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. | |
| 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. | |
| 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. | |
| 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. | |
| 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. | |
| 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. | |
| 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. | |
| 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. | |
| 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. | |
| 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.