EventType EventType EventType Enum

Definition

Specifies the various different types of events that are supported by SQL Server.

public enum class EventType
public enum EventType
Public Enum EventType
Inheritance
EventTypeEventTypeEventType

Fields

AddRoleMember AddRoleMember AddRoleMember 0

Event that occurs when a member is added to a database role.

AddServerRoleMember AddServerRoleMember AddServerRoleMember 1

Event that occurs when a member is added to a server role.

AddSignature AddSignature AddSignature 2

Event that occurs when a signature is added.

AddSignatureSchemaObject AddSignatureSchemaObject AddSignatureSchemaObject 3

Event that occurs when an AddSignatureSchemaObject is added to a database.

AlterApplicationRole AlterApplicationRole AlterApplicationRole 4

Event that occurs when an application role is altered.

AlterAssembly AlterAssembly AlterAssembly 5

Event that occurs when an assembly is altered.

AlterAsymmetricKey AlterAsymmetricKey AlterAsymmetricKey 6

Event that occurs when an asymmetric key is altered.

AlterAudit AlterAudit AlterAudit 7

Event that occurs when an audit is altered.

AlterAuthorizationDatabase AlterAuthorizationDatabase AlterAuthorizationDatabase 8

Event that occurs when an authorization database is altered.

AlterAuthorizationServer AlterAuthorizationServer AlterAuthorizationServer 9

Event that occurs when an authorization server is altered.

AlterAvailabilityGroup AlterAvailabilityGroup AlterAvailabilityGroup 10

Event that occurs when the availability group is altered.

AlterBrokerPriority AlterBrokerPriority AlterBrokerPriority 11

Event that occurs when a broker priority is altered.

AlterCertificate AlterCertificate AlterCertificate 12

Event that occurs when a certificate is altered.

AlterColumnEncryptionKey AlterColumnEncryptionKey AlterColumnEncryptionKey 13

Event that occurs when a column encryption key is altered.

AlterCredential AlterCredential AlterCredential 14

Event that occurs when a credential is altered.

AlterCryptographicProvider AlterCryptographicProvider AlterCryptographicProvider 15

Event that occurs when a cryptographic provider is altered.

AlterDatabase AlterDatabase AlterDatabase 16

Event that occurs when a database is altered.

AlterDatabaseAuditSpecification AlterDatabaseAuditSpecification AlterDatabaseAuditSpecification 17

Event that occurs when a database audit specification is altered.

AlterDatabaseEncryptionKey AlterDatabaseEncryptionKey AlterDatabaseEncryptionKey 18

Event that occurs when a database encryption key is altered.

AlterEndpoint AlterEndpoint AlterEndpoint 19

Event that occurs when an HTTP endpoint is altered.

AlterEventSession AlterEventSession AlterEventSession 20

Event that occurs when an event session is altered.

AlterExtendedProperty AlterExtendedProperty AlterExtendedProperty 21

Event that occurs when an extended property is altered.

AlterFulltextCatalog AlterFulltextCatalog AlterFulltextCatalog 22

Event that occurs when a Full-Text catalog is altered.

AlterFulltextIndex AlterFulltextIndex AlterFulltextIndex 23

Event that occurs when a Full-Text index is altered.

AlterFulltextStoplist AlterFulltextStoplist AlterFulltextStoplist 24

Event that occurs when a Full-Text stop list is altered.

AlterFunction AlterFunction AlterFunction 25

Event that occurs when a function is altered.

AlterIndex AlterIndex AlterIndex 26

Event that occurs when an index is altered.

AlterInstance AlterInstance AlterInstance 27

Event that occurs when a server instance is altered.

AlterLinkedServer AlterLinkedServer AlterLinkedServer 28

Event that occurs when a linked server is altered.

AlterLogin AlterLogin AlterLogin 29

Event that occurs when a login is altered.

AlterMasterKey AlterMasterKey AlterMasterKey 30

Event that occurs when a master key is altered.

AlterMessage AlterMessage AlterMessage 31

Event that occurs when a message is altered.

AlterMessageType AlterMessageType AlterMessageType 32

Event that occurs when a message is altered.

AlterPartitionFunction AlterPartitionFunction AlterPartitionFunction 33

Event that occurs when a partition function is altered.

AlterPartitionScheme AlterPartitionScheme AlterPartitionScheme 34

Event that occurs when a partition scheme is altered.

AlterPlanGuide AlterPlanGuide AlterPlanGuide 35

Event that occurs when a plan guide is altered.

AlterProcedure AlterProcedure AlterProcedure 36

Event that occurs when a stored procedure is altered.

AlterQueue AlterQueue AlterQueue 37

Event that occurs when a queue is altered.

AlterRemoteServer AlterRemoteServer AlterRemoteServer 38

Event that occurs when a remote server is altered.

AlterRemoteServiceBinding AlterRemoteServiceBinding AlterRemoteServiceBinding 39

Event that occurs when a remote service binding is altered.

AlterResourceGovernorConfig AlterResourceGovernorConfig AlterResourceGovernorConfig 40

Event that occurs when the resource governor configuration is altered.

AlterResourcePool AlterResourcePool AlterResourcePool 41

Event that occurs when a resource pool is altered.

AlterRole AlterRole AlterRole 42

Event that occurs when a role is altered.

AlterRoute AlterRoute AlterRoute 43

Event that occurs when a route is altered.

AlterSchema AlterSchema AlterSchema 44

Event that occurs when a schema is altered.

AlterSearchPropertyList AlterSearchPropertyList AlterSearchPropertyList 45

Event that occurs when a search property list is altered.

AlterSecurityPolicy AlterSecurityPolicy AlterSecurityPolicy 46

Event that occurs when a security policy is altered.

AlterSequence AlterSequence AlterSequence 47

Event that occurs when a sequence is altered.

AlterServerAudit AlterServerAudit AlterServerAudit 48

Event that occurs when a server audit is altered.

AlterServerAuditSpecification AlterServerAuditSpecification AlterServerAuditSpecification 49

Event that occurs when a server audit specification is altered.

AlterServerConfiguration AlterServerConfiguration AlterServerConfiguration 50

Event that occurs when a server configuration is altered.

AlterServerRole AlterServerRole AlterServerRole 51

Event that occurs when a server role is altered.

AlterService AlterService AlterService 52

Event that occurs when a service is altered.

AlterServiceMasterKey AlterServiceMasterKey AlterServiceMasterKey 53

Event that occurs when a service master key is altered.

AlterSymmetricKey AlterSymmetricKey AlterSymmetricKey 54

Event that occurs when a symmetric key is altered.

AlterTable AlterTable AlterTable 55

Event that occurs when a table is altered.

AlterTrigger AlterTrigger AlterTrigger 56

Event that occurs when a trigger is altered.

AlterUser AlterUser AlterUser 57

Event that occurs when a user is altered.

AlterView AlterView AlterView 58

Event that occurs when a view is altered.

AlterWorkloadGroup AlterWorkloadGroup AlterWorkloadGroup 59

Event that occurs when a workload group is altered.

AlterXmlSchemaCollection AlterXmlSchemaCollection AlterXmlSchemaCollection 60

Event that occurs when an XML schema collection is altered.

AssemblyLoad AssemblyLoad AssemblyLoad 61

Event that occurs when an assembly is loaded.

AuditAddDBUserEvent AuditAddDBUserEvent AuditAddDBUserEvent 63

Event that occurs when adding a database user is audited.

AuditAddloginEvent AuditAddloginEvent AuditAddloginEvent 62

Event that occurs when adding a login is audited.

AuditAddLoginToServerRoleEvent AuditAddLoginToServerRoleEvent AuditAddLoginToServerRoleEvent 64

Event that occurs when adding a login to a server role is audited.

AuditAddMemberToDBRoleEvent AuditAddMemberToDBRoleEvent AuditAddMemberToDBRoleEvent 65

Event that occurs when adding a member to a database role is audited.

AuditAddRoleEvent AuditAddRoleEvent AuditAddRoleEvent 66

Event that occurs when adding a role is audited.

AuditAppRoleChangePasswordEvent AuditAppRoleChangePasswordEvent AuditAppRoleChangePasswordEvent 67

Event that occurs when changing an application role password is audited.

AuditBackupRestoreEvent AuditBackupRestoreEvent AuditBackupRestoreEvent 68

Event that occurs when backing up or restoring is audited.

AuditChangeAuditEvent AuditChangeAuditEvent AuditChangeAuditEvent 69

Event that occurs when changing an audit event is audited.

AuditChangeDatabaseOwner AuditChangeDatabaseOwner AuditChangeDatabaseOwner 70

Event that occurs when changing the database owner is audited.

AuditDatabaseManagementEvent AuditDatabaseManagementEvent AuditDatabaseManagementEvent 71

Event that occurs when database management is audited.

AuditDatabaseObjectAccessEvent AuditDatabaseObjectAccessEvent AuditDatabaseObjectAccessEvent 72

Event that occurs when accessing a database object is audited.

AuditDatabaseObjectGdrEvent AuditDatabaseObjectGdrEvent AuditDatabaseObjectGdrEvent 73

Event that occurs when a database object's GDR is audited.

AuditDatabaseObjectManagementEvent AuditDatabaseObjectManagementEvent AuditDatabaseObjectManagementEvent 74

Event that occurs when database object management is audited.

AuditDatabaseObjectTakeOwnershipEvent AuditDatabaseObjectTakeOwnershipEvent AuditDatabaseObjectTakeOwnershipEvent 75

Event that occurs when taking ownership of a database object is audited.

AuditDatabaseOperationEvent AuditDatabaseOperationEvent AuditDatabaseOperationEvent 76

Event that occurs when database operations are audited.

AuditDatabasePrincipalImpersonationEvent AuditDatabasePrincipalImpersonationEvent AuditDatabasePrincipalImpersonationEvent 77

Event that occurs when database principal impersonation is audited.

AuditDatabasePrincipalManagementEvent AuditDatabasePrincipalManagementEvent AuditDatabasePrincipalManagementEvent 78

Event that occurs when database principal management is audited.

AuditDatabaseScopeGdrEvent AuditDatabaseScopeGdrEvent AuditDatabaseScopeGdrEvent 79

Event that occurs when database scope GDR is audited.

AuditDbccEvent AuditDbccEvent AuditDbccEvent 80

Event that occurs when a database consistency check (DBCC) event is audited.

AuditFulltext AuditFulltext AuditFulltext 81

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

AuditLogin AuditLogin AuditLogin 82

Event that occurs when a login is audited.

AuditLoginChangePasswordEvent AuditLoginChangePasswordEvent AuditLoginChangePasswordEvent 83

Event that occurs when a login password change is audited.

AuditLoginChangePropertyEvent AuditLoginChangePropertyEvent AuditLoginChangePropertyEvent 84

Event that occurs when a login property change is audited.

AuditLoginFailed AuditLoginFailed AuditLoginFailed 85

Event that occurs when a failed login attempt is audited.

AuditLoginGdrEvent AuditLoginGdrEvent AuditLoginGdrEvent 86

Event that occurs when a login GDR event is audited.

AuditLogout AuditLogout AuditLogout 87

Event that occurs when a log out is audited.

AuditSchemaObjectAccessEvent AuditSchemaObjectAccessEvent AuditSchemaObjectAccessEvent 88

Event that occurs when access to a schema object is audited.

AuditSchemaObjectGdrEvent AuditSchemaObjectGdrEvent AuditSchemaObjectGdrEvent 89

Event that occurs when a schema object GDR is audited.

AuditSchemaObjectManagementEvent AuditSchemaObjectManagementEvent AuditSchemaObjectManagementEvent 90

Event that occurs when schema object management is audited.

AuditSchemaObjectTakeOwnershipEvent AuditSchemaObjectTakeOwnershipEvent AuditSchemaObjectTakeOwnershipEvent 91

Event that occurs when taking ownership of a schema object is audited.

AuditServerAlterTraceEvent AuditServerAlterTraceEvent AuditServerAlterTraceEvent 92

Event that occurs when an alter server trace is audited.

AuditServerObjectGdrEvent AuditServerObjectGdrEvent AuditServerObjectGdrEvent 93

Event that occurs when a server object GDR is audited.

AuditServerObjectManagementEvent AuditServerObjectManagementEvent AuditServerObjectManagementEvent 94

Event that occurs when server object management is audited.

AuditServerObjectTakeOwnershipEvent AuditServerObjectTakeOwnershipEvent AuditServerObjectTakeOwnershipEvent 95

Event that occurs when taking ownership of the server object is audited.

AuditServerOperationEvent AuditServerOperationEvent AuditServerOperationEvent 96

Event that occurs when server operation is audited.

AuditServerPrincipalImpersonationEvent AuditServerPrincipalImpersonationEvent AuditServerPrincipalImpersonationEvent 97

Event that occurs when server principal impersonation is audited.

AuditServerPrincipalManagementEvent AuditServerPrincipalManagementEvent AuditServerPrincipalManagementEvent 98

Event that occurs when server principal management is audited.

AuditServerScopeGdrEvent AuditServerScopeGdrEvent AuditServerScopeGdrEvent 99

Event that occurs when server scope GDR is audited.

BindDefault BindDefault BindDefault 100

Event that occurs when a default is bound to a column or to an alias data type.

BindRule BindRule BindRule 101

Event that occurs when a rule is bound to a column or to an alias data type.

BitmapWarning BitmapWarning BitmapWarning 102

Can be used to report when bitmap filters have been disabled in a query.

BlockedProcessReport BlockedProcessReport BlockedProcessReport 103

Event that occurs when a blocked process is reported.

BrokerQueueDisabled BrokerQueueDisabled BrokerQueueDisabled 104

Event that occurs when a Service Broker queue is disabled.

CpuThresholdExceeded CpuThresholdExceeded CpuThresholdExceeded 105

Event that occurs when the CPU threshold has been exceeded.

CreateApplicationRole CreateApplicationRole CreateApplicationRole 106

Event that occurs when an application role is created.

CreateAssembly CreateAssembly CreateAssembly 107

Event that occurs when a server assembly is created.

CreateAsymmetricKey CreateAsymmetricKey CreateAsymmetricKey 108

Event that occurs when an asymmetric key is created.

CreateAudit CreateAudit CreateAudit 109

Event that occurs when an audit is created.

CreateAvailabilityGroup CreateAvailabilityGroup CreateAvailabilityGroup 110

Event that occurs when the availability group is created.

CreateBrokerPriority CreateBrokerPriority CreateBrokerPriority 111

Event that occurs when a broker priority is created.

CreateCertificate CreateCertificate CreateCertificate 112

Event that occurs when a certificate is created.

CreateColumnEncryptionKey CreateColumnEncryptionKey CreateColumnEncryptionKey 113

Event that occurs when a column encryption key is created.

CreateColumnMasterKey CreateColumnMasterKey CreateColumnMasterKey 114

Event that occurs when a column master key is created.

CreateContract CreateContract CreateContract 115

Event that occurs when a contract is created.

CreateCredential CreateCredential CreateCredential 116

Event that occurs when a credential is created.

CreateCryptographicProvider CreateCryptographicProvider CreateCryptographicProvider 117

Event that occurs when cryptographic provider is created.

CreateDatabase CreateDatabase CreateDatabase 118

Event that occurs when a database is created.

CreateDatabaseAuditSpecification CreateDatabaseAuditSpecification CreateDatabaseAuditSpecification 119

Event that occurs when a database audit specification is created.

CreateDatabaseEncryptionKey CreateDatabaseEncryptionKey CreateDatabaseEncryptionKey 120

Event that occurs when a database encryption key is created.

CreateDefault CreateDefault CreateDefault 121

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 CreateEndpoint CreateEndpoint 122

Event that occurs when an endpoint is created.

CreateEventNotification CreateEventNotification CreateEventNotification 123

Event that occurs when event notification is created.

CreateEventSession CreateEventSession CreateEventSession 124

Event that occurs when an event session is created.

CreateExtendedProcedure CreateExtendedProcedure CreateExtendedProcedure 125

Event that occurs when an extended stored procedure is created.

CreateExtendedProperty CreateExtendedProperty CreateExtendedProperty 126

Event that occurs when an extended property is created.

CreateFulltextCatalog CreateFulltextCatalog CreateFulltextCatalog 127

Event that occurs when a Full-Text catalog is created.

CreateFulltextIndex CreateFulltextIndex CreateFulltextIndex 128

Event that occurs when a Full-Text index is created.

CreateFulltextStoplist CreateFulltextStoplist CreateFulltextStoplist 129

Event that occurs when a Full-Text stop list is created.

CreateFunction CreateFunction CreateFunction 130

Event that occurs when a function is created.

CreateIndex CreateIndex CreateIndex 131

Event that occurs when an index is created.

CreateLinkedServer CreateLinkedServer CreateLinkedServer 132

Event that occurs when a linked server is created.

CreateLinkedServerLogin CreateLinkedServerLogin CreateLinkedServerLogin 133

Event that occurs when a linked server login is created.

CreateLogin CreateLogin CreateLogin 134

Event that occurs when a login is created.

CreateMasterKey CreateMasterKey CreateMasterKey 135

Event that occurs when a master key is created.

CreateMessage CreateMessage CreateMessage 136

Event that occurs when a message is created.

CreateMessageType CreateMessageType CreateMessageType 137

Event that occurs when a message type is created.

CreatePartitionFunction CreatePartitionFunction CreatePartitionFunction 138

Event that occurs when a partition function is created.

CreatePartitionScheme CreatePartitionScheme CreatePartitionScheme 139

Event that occurs when a partition scheme is created.

CreatePlanGuide CreatePlanGuide CreatePlanGuide 140

Event that occurs when a plan guide is created.

CreateProcedure CreateProcedure CreateProcedure 141

Event that occurs when a stored procedure is created.

CreateQueue CreateQueue CreateQueue 142

Event that occurs when a queue is created.

CreateRemoteServer CreateRemoteServer CreateRemoteServer 143

Event that occurs when a remote server is created.

CreateRemoteServiceBinding CreateRemoteServiceBinding CreateRemoteServiceBinding 144

Event that occurs when a remote service binding is created.

CreateResourcePool CreateResourcePool CreateResourcePool 145

Event that occurs when a resource pool is created.

CreateRole CreateRole CreateRole 146

Event that occurs when a role is created.

CreateRoute CreateRoute CreateRoute 147

Event that occurs when a route is created.

CreateRule CreateRule CreateRule 148

Event that occurs when a rule is created.

CreateSchema CreateSchema CreateSchema 149

Event that occurs when a schema is created.

CreateSearchPropertyList CreateSearchPropertyList CreateSearchPropertyList 150

Event that occurs when a search property list is created.

CreateSecurityPolicy CreateSecurityPolicy CreateSecurityPolicy 151

Event that occurs when a security policy is created.

CreateSequence CreateSequence CreateSequence 152

Event that occurs when a sequence is created.

CreateServerAudit CreateServerAudit CreateServerAudit 153

Event that occurs when a server audit is created.

CreateServerAuditSpecification CreateServerAuditSpecification CreateServerAuditSpecification 154

Event that occurs when a server audit specification is created.

CreateServerRole CreateServerRole CreateServerRole 155

Event that occurs when a server role is created.

CreateService CreateService CreateService 156

Event that occurs when a service is created.

CreateSpatialIndex CreateSpatialIndex CreateSpatialIndex 157

Event that occurs when a spatial index is created.

CreateStatistics CreateStatistics CreateStatistics 158

Event that occurs when a statistics counter is created.

CreateSymmetricKey CreateSymmetricKey CreateSymmetricKey 159

Event that occurs when a symmetric key is created.

CreateSynonym CreateSynonym CreateSynonym 160

Event that occurs when a synonym is created.

CreateTable CreateTable CreateTable 161

Event that occurs when a table is created.

CreateTrigger CreateTrigger CreateTrigger 162

Event that occurs when a trigger is created.

CreateType CreateType CreateType 163

Event that occurs when a type is created.

CreateUser CreateUser CreateUser 164

Event that occurs when a user is created.

CreateView CreateView CreateView 165

Event that occurs when a view is created.

CreateWorkloadGroup CreateWorkloadGroup CreateWorkloadGroup 166

Event that occurs when a workload group is created.

CreateXmlIndex CreateXmlIndex CreateXmlIndex 167

Event that occurs when an XML index is created.

CreateXmlSchemaCollection CreateXmlSchemaCollection CreateXmlSchemaCollection 168

Event that occurs when an XML schema collection is created.

DatabaseMirroringStateChange DatabaseMirroringStateChange DatabaseMirroringStateChange 169

Event that occurs when the mirroring state of a database changes.

DatabaseSuspectDataPage DatabaseSuspectDataPage DatabaseSuspectDataPage 170

Event that occurs when a suspect data page is detected in the database.

DataFileAutoGrow DataFileAutoGrow DataFileAutoGrow 171

Event that occurs when a data file grows automatically.

DataFileAutoShrink DataFileAutoShrink DataFileAutoShrink 172

Event that occurs when a data file shrinks automatically.

DeadlockGraph DeadlockGraph DeadlockGraph 173

Event that occurs when a deadlock graph occurs.

DenyDatabase DenyDatabase DenyDatabase 174

Event that occurs when a database denies access.

DenyServer DenyServer DenyServer 175

Event that occurs when a server denies access.

DeprecationAnnouncement DeprecationAnnouncement DeprecationAnnouncement 176

Event that occurs when a deprecation announcement is issued.

DeprecationFinalSupport DeprecationFinalSupport DeprecationFinalSupport 177

Event that occurs when a deprecation final support message is issued.

DropApplicationRole DropApplicationRole DropApplicationRole 178

Event that occurs when an application role is dropped.

DropAssembly DropAssembly DropAssembly 179

Event that occurs when an assembly is dropped.

DropAsymmetricKey DropAsymmetricKey DropAsymmetricKey 180

Event that occurs when an asymmetric key is dropped.

DropAudit DropAudit DropAudit 181

Event that occurs when an audit is dropped.

DropAvailabilityGroup DropAvailabilityGroup DropAvailabilityGroup 182

Event that occurs when the availability group is dropped.

DropBrokerPriority DropBrokerPriority DropBrokerPriority 183

Event that occurs when a broker priority is dropped.

DropCertificate DropCertificate DropCertificate 184

Event that occurs when a certificate is dropped.

DropColumnEncryptionKey DropColumnEncryptionKey DropColumnEncryptionKey 185

Event that occurs when a column encryption key is dropped.

DropColumnMasterKey DropColumnMasterKey DropColumnMasterKey 186

Event that occurs when a column master key is dropped.

DropContract DropContract DropContract 187

Event that occurs when a contract is dropped.

DropCredential DropCredential DropCredential 188

Event that occurs when a credential is dropped.

DropCryptographicProvider DropCryptographicProvider DropCryptographicProvider 189

Event that occurs when a cryptographic provider is dropped.

DropDatabase DropDatabase DropDatabase 190

Event that occurs when a database is dropped.

DropDatabaseAuditSpecification DropDatabaseAuditSpecification DropDatabaseAuditSpecification 191

Event that occurs when a database audit specification is dropped.

DropDatabaseEncryptionKey DropDatabaseEncryptionKey DropDatabaseEncryptionKey 192

Event that occurs when a database encryption key is dropped.

DropDefault DropDefault DropDefault 193

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 DropEndpoint DropEndpoint 194

Event that occurs when an HTTP endpoint is dropped.

DropEventNotification DropEventNotification DropEventNotification 195

Event that occurs when an event notification is dropped.

DropEventSession DropEventSession DropEventSession 196

Event that occurs when an event session is dropped.

DropExtendedProcedure DropExtendedProcedure DropExtendedProcedure 197

Event that occurs when an extended procedure is dropped.

DropExtendedProperty DropExtendedProperty DropExtendedProperty 198

Event that occurs when an extended property is dropped.

DropFulltextCatalog DropFulltextCatalog DropFulltextCatalog 199

Event that occurs when a Full-Text catalog is dropped.

DropFulltextIndex DropFulltextIndex DropFulltextIndex 200

Event that occurs when a Full-Text index is dropped.

DropFulltextStoplist DropFulltextStoplist DropFulltextStoplist 201

Event that occurs when a Full-Text stop list is dropped.

DropFunction DropFunction DropFunction 202

Event that occurs when a function is dropped.

DropIndex DropIndex DropIndex 203

Event that occurs when an index is dropped.

DropLinkedServer DropLinkedServer DropLinkedServer 204

Event that occurs when a linked server is dropped.

DropLinkedServerLogin DropLinkedServerLogin DropLinkedServerLogin 205

Event that occurs when a linked server login is dropped.

DropLogin DropLogin DropLogin 206

Event that occurs when a login is dropped.

DropMasterKey DropMasterKey DropMasterKey 207

Event that occurs when a master key is dropped..

DropMessage DropMessage DropMessage 208

Event that occurs when a message is dropped.

DropMessageType DropMessageType DropMessageType 209

Event that occurs when a message is dropped.

DropPartitionFunction DropPartitionFunction DropPartitionFunction 210

Event that occurs when a partition function is dropped.

DropPartitionScheme DropPartitionScheme DropPartitionScheme 211

Event that occurs when a partition scheme is dropped.

DropPlanGuide DropPlanGuide DropPlanGuide 212

Event that occurs when a plan guide is dropped.

DropProcedure DropProcedure DropProcedure 213

Event that occurs when a procedure is dropped.

DropQueue DropQueue DropQueue 214

Event that occurs when a queue is dropped.

DropRemoteServer DropRemoteServer DropRemoteServer 215

Event that occurs when a remote server is dropped..

DropRemoteServiceBinding DropRemoteServiceBinding DropRemoteServiceBinding 216

Event that occurs when a remote service binding is dropped.

DropResourcePool DropResourcePool DropResourcePool 217

Event that occurs when a resource pool is dropped.

DropRole DropRole DropRole 218

Event that occurs when a role is dropped.

DropRoleMember DropRoleMember DropRoleMember 219

Event that occurs when a member of a role is dropped.

DropRoute DropRoute DropRoute 220

Event that occurs when a route is dropped.

DropRule DropRule DropRule 221

Event that occurs when a rule is dropped.

DropSchema DropSchema DropSchema 222

Event that occurs when a schema is dropped.

DropSearchPropertyList DropSearchPropertyList DropSearchPropertyList 223

Event that occurs when a search property list is dropped.

DropSecurityPolicy DropSecurityPolicy DropSecurityPolicy 224

Event that occurs when security policy is dropped.

DropSequence DropSequence DropSequence 225

Event that occurs when a sequence is dropped.

DropServerAudit DropServerAudit DropServerAudit 226

Event that occurs when a server audit is dropped.

DropServerAuditSpecification DropServerAuditSpecification DropServerAuditSpecification 227

Event that occurs when a server audit specification is dropped.

DropServerRole DropServerRole DropServerRole 228

Event that occurs when a server role is dropped.

DropServerRoleMember DropServerRoleMember DropServerRoleMember 229

Event that occurs when a member of a server role is dropped.

DropService DropService DropService 230

Event that occurs when a service is dropped.

DropSignature DropSignature DropSignature 231

Event that occurs when a signature is dropped.

DropSignatureSchemaObject DropSignatureSchemaObject DropSignatureSchemaObject 232

Event that occurs when a signature schema object is dropped.

DropStatistics DropStatistics DropStatistics 233

Event that occurs when a statistics counter is dropped.

DropSymmetricKey DropSymmetricKey DropSymmetricKey 234

Event that occurs when a symmetric key is dropped.

DropSynonym DropSynonym DropSynonym 235

Event that occurs when a synonym is dropped.

DropTable DropTable DropTable 236

Event that occurs when a table is dropped.

DropTrigger DropTrigger DropTrigger 237

Event that occurs when a trigger is dropped.

DropType DropType DropType 238

Event that occurs when a type is dropped.

DropUser DropUser DropUser 239

Event that occurs when a user is dropped.

DropView DropView DropView 240

Event that occurs when a view is dropped.

DropWorkloadGroup DropWorkloadGroup DropWorkloadGroup 241

Event that occurs when a workload group is dropped.

DropXmlSchemaCollection DropXmlSchemaCollection DropXmlSchemaCollection 242

Event that occurs when an XML schema collection is dropped.

Errorlog Errorlog Errorlog 243

Event that occurs when an error is logged.

Eventlog Eventlog Eventlog 244

Event that occurs when an event is logged.

Exception Exception Exception 245

Event that occurs when an exception occurs.

ExchangeSpillEvent ExchangeSpillEvent ExchangeSpillEvent 246

Event that occurs when an exchange spill event occurs.

ExecutionWarnings ExecutionWarnings ExecutionWarnings 247

Event that occurs when an execution warning occurs.

FtCrawlAborted FtCrawlAborted FtCrawlAborted 248

Event that occurs when a Full-Text crawl is stopped.

FtCrawlStarted FtCrawlStarted FtCrawlStarted 249

Event that occurs when an FT crawl is started.

FtCrawlStopped FtCrawlStopped FtCrawlStopped 250

Event that occurs when an FT crawl is stopped.

GrantDatabase GrantDatabase GrantDatabase 251

Event that occurs when access is granted to a database.

GrantServer GrantServer GrantServer 252

Event that occurs when access to a server is granted.

HashWarning HashWarning HashWarning 253

Event that occurs when a hash warning occurs.

LockDeadlock LockDeadlock LockDeadlock 254

Event that occurs when a deadlock occurs.

LockDeadlockChain LockDeadlockChain LockDeadlockChain 255

Event that occurs when a deadlock chain occurs.

LockEscalation LockEscalation LockEscalation 256

Event that occurs when lock escalation occurs.

LogFileAutoGrow LogFileAutoGrow LogFileAutoGrow 257

Event that occurs when the log file automatically grows.

LogFileAutoShrink LogFileAutoShrink LogFileAutoShrink 258

Event that occurs when log file is automatically shrinked.

MissingColumnStatistics MissingColumnStatistics MissingColumnStatistics 259

Event that occurs when missing columns statistics are discovered.

MissingJoinPredicate MissingJoinPredicate MissingJoinPredicate 260

Event that occurs when a missing join predicate occurs.

MountTape MountTape MountTape 261

Event that occurs when tape is mounted.

ObjectAltered ObjectAltered ObjectAltered 262

Event that occurs when an object is altered.

ObjectCreated ObjectCreated ObjectCreated 263

Event that occurs when an object is created.

ObjectDeleted ObjectDeleted ObjectDeleted 264

Event that occurs when an object is deleted.

OledbCallEvent OledbCallEvent OledbCallEvent 265

Event that occurs when an OLE DB call event occurs.

OledbDatareadEvent OledbDatareadEvent OledbDatareadEvent 266

Event that occurs when an OLE DB data is read.

OledbErrors OledbErrors OledbErrors 267

Event that occurs when OLE DB errors occur.

OledbProviderInformation OledbProviderInformation OledbProviderInformation 268

Event that occurs when OLE DB provider information is accessed.

OledbQueryinterfaceEvent OledbQueryinterfaceEvent OledbQueryinterfaceEvent 269

Event that occurs when an OLE DB interface is queried.

Qn_dynamics Qn_dynamics Qn_dynamics 270

Event that occurs when a dynamics event occurs.

Qn_parameterTable Qn_parameterTable Qn_parameterTable 271

Event that occurs when a parameter table event occurs.

Qn_subscription Qn_subscription Qn_subscription 272

Event that occurs when a subscription event occurs.

Qn_template Qn_template Qn_template 273

Event that occurs when a template event occurs.

QueueActivation QueueActivation QueueActivation 274

Event that occurs when a queue is activated.

Rename Rename Rename 275

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

RevokeDatabase RevokeDatabase RevokeDatabase 276

Event that occurs when access to a database is revoked.

RevokeServer RevokeServer RevokeServer 277

Event that occurs when access to a server is revoked.

ServerMemoryChange ServerMemoryChange ServerMemoryChange 278

Event that occurs when a change to the server memory is made.

ShowplanAllForQueryCompile ShowplanAllForQueryCompile ShowplanAllForQueryCompile 279

Event that occurs when a Showplan All For Query Compile request occurs.

ShowplanXml ShowplanXml ShowplanXml 280

Event that occurs when a Showplan XML request occurs.

ShowplanXmlForQueryCompile ShowplanXmlForQueryCompile ShowplanXmlForQueryCompile 281

Event that occurs when a Showplan XML For Query Compile request occurs.

ShowplanXmlStatisticsProfile ShowplanXmlStatisticsProfile ShowplanXmlStatisticsProfile 282

Event that occurs when a Showplan XML statistics profile request occurs.

SortWarnings SortWarnings SortWarnings 283

Event that occurs when a warning message is generated during a sort operation.

SpCacheinsert SpCacheinsert SpCacheinsert 284

Event that occurs when a stored procedure cache insert occurs.

SpCachemiss SpCachemiss SpCachemiss 285

Event that occurs when a stored procedure cache miss occurs.

SpCacheremove SpCacheremove SpCacheremove 286

Event that occurs when a stored procedure cache remove occurs.

SpRecompile SpRecompile SpRecompile 287

Event that occurs when a stored procedure is recompiled.

SqlStmtrecompile SqlStmtrecompile SqlStmtrecompile 288

Event that occurs when a Transact-SQL statement is recompiled.

TraceFileClose TraceFileClose TraceFileClose 289

Event that occurs when a trace file is closed.

UnbindDefault UnbindDefault UnbindDefault 290

Event that occurs when a default is unbound.

UnbindRule UnbindRule UnbindRule 291

Event that occurs when a rule is unbound.

UpdateStatistics UpdateStatistics UpdateStatistics 292

Event that occurs when statistics are updated.

Userconfigurable0 Userconfigurable0 Userconfigurable0 293

A user-configurable event.

Userconfigurable1 Userconfigurable1 Userconfigurable1 294

A user-configurable event.

Userconfigurable2 Userconfigurable2 Userconfigurable2 295

A user-configurable event.

Userconfigurable3 Userconfigurable3 Userconfigurable3 296

A user-configurable event.

Userconfigurable4 Userconfigurable4 Userconfigurable4 297

A user-configurable event.

Userconfigurable5 Userconfigurable5 Userconfigurable5 298

A user-configurable event.

Userconfigurable6 Userconfigurable6 Userconfigurable6 299

A user-configurable event.

Userconfigurable7 Userconfigurable7 Userconfigurable7 300

A user-configurable event.

Userconfigurable8 Userconfigurable8 Userconfigurable8 301

A user-configurable event.

Userconfigurable9 Userconfigurable9 Userconfigurable9 302

A user-configurable event.

UserErrorMessage UserErrorMessage UserErrorMessage 303

Event that occurs when a user error message is issued.

XqueryStaticType XqueryStaticType XqueryStaticType 304

Event that occurs when an XQuery static type event occurs.

Remarks

The EventType enumeration class is served by the EventType class.

Applies to