ServerTraceEvent ServerTraceEvent ServerTraceEvent Class

Definition

The ServerTraceEvent object represents the SQL Server server trace events that can be included in a server trace event set.

public ref class ServerTraceEvent sealed
public sealed class ServerTraceEvent
Public NotInheritable Class ServerTraceEvent
Inheritance
ServerTraceEventServerTraceEventServerTraceEvent

Examples

Handling SMO Events

Remarks

The ServerTraceEvent object contains a property for each trace event to which the instance of SQL Server can respond. The actual set of trace events is specified using the ServerTraceEventSet object.

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

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Properties

AssemblyLoad AssemblyLoad AssemblyLoad

Gets a server trace event that can be included in the event set.

AuditAddDBUserEvent AuditAddDBUserEvent AuditAddDBUserEvent

Gets a server trace event that can be included in the event set.

AuditAddloginEvent AuditAddloginEvent AuditAddloginEvent

Gets a server trace event that can be included in the event set.

AuditAddLoginToServerRoleEvent AuditAddLoginToServerRoleEvent AuditAddLoginToServerRoleEvent

Gets a server trace event that can be included in the event set.

AuditAddMemberToDBRoleEvent AuditAddMemberToDBRoleEvent AuditAddMemberToDBRoleEvent

Gets a server trace event that can be included in the event set.

AuditAddRoleEvent AuditAddRoleEvent AuditAddRoleEvent

Gets a server trace event that can be included in the event set.

AuditAppRoleChangePasswordEvent AuditAppRoleChangePasswordEvent AuditAppRoleChangePasswordEvent

Gets a server trace event that can be included in the event set.

AuditBackupRestoreEvent AuditBackupRestoreEvent AuditBackupRestoreEvent

Gets a server trace event that can be included in the event set.

AuditChangeAuditEvent AuditChangeAuditEvent AuditChangeAuditEvent

Gets a server trace event that can be included in the event set.

AuditChangeDatabaseOwner AuditChangeDatabaseOwner AuditChangeDatabaseOwner

Gets a server trace event that can be included in the event set.

AuditDatabaseManagementEvent AuditDatabaseManagementEvent AuditDatabaseManagementEvent

Gets a server trace event that can be included in the event set.

AuditDatabaseObjectAccessEvent AuditDatabaseObjectAccessEvent AuditDatabaseObjectAccessEvent

Gets a server trace event that can be included in the event set.

AuditDatabaseObjectGdrEvent AuditDatabaseObjectGdrEvent AuditDatabaseObjectGdrEvent

Gets a server trace event that can be included in the event set.

AuditDatabaseObjectManagementEvent AuditDatabaseObjectManagementEvent AuditDatabaseObjectManagementEvent

Gets a server trace event that can be included in the event set.

AuditDatabaseObjectTakeOwnershipEvent AuditDatabaseObjectTakeOwnershipEvent AuditDatabaseObjectTakeOwnershipEvent

Gets a server trace event that can be included in the event set.

AuditDatabaseOperationEvent AuditDatabaseOperationEvent AuditDatabaseOperationEvent

Gets a server trace event that can be included in the event set.

AuditDatabasePrincipalImpersonationEvent AuditDatabasePrincipalImpersonationEvent AuditDatabasePrincipalImpersonationEvent

Gets a server trace event that can be included in the event set.

AuditDatabasePrincipalManagementEvent AuditDatabasePrincipalManagementEvent AuditDatabasePrincipalManagementEvent

Gets a server trace event that can be included in the event set.

AuditDatabaseScopeGdrEvent AuditDatabaseScopeGdrEvent AuditDatabaseScopeGdrEvent

Gets a server trace event that can be included in the event set.

AuditDbccEvent AuditDbccEvent AuditDbccEvent

Gets a server trace event that can be included in the event set.

AuditFulltext AuditFulltext AuditFulltext

Gets a server trace event that can be included in the event set.

AuditLogin AuditLogin AuditLogin

Gets a server trace event that can be included in the event set.

AuditLoginChangePasswordEvent AuditLoginChangePasswordEvent AuditLoginChangePasswordEvent

Gets a server trace event that can be included in the event set.

AuditLoginChangePropertyEvent AuditLoginChangePropertyEvent AuditLoginChangePropertyEvent

Gets a server trace event that can be included in the event set.

AuditLoginFailed AuditLoginFailed AuditLoginFailed

Gets a server trace event that can be included in the event set.

AuditLoginGdrEvent AuditLoginGdrEvent AuditLoginGdrEvent

Gets a server trace event that can be included in the event set.

AuditLogout AuditLogout AuditLogout

Gets a server trace event that can be included in the event set.

AuditSchemaObjectAccessEvent AuditSchemaObjectAccessEvent AuditSchemaObjectAccessEvent

Gets a server trace event that can be included in the event set.

AuditSchemaObjectGdrEvent AuditSchemaObjectGdrEvent AuditSchemaObjectGdrEvent

Gets a server trace event that can be included in the event set.

AuditSchemaObjectManagementEvent AuditSchemaObjectManagementEvent AuditSchemaObjectManagementEvent

Gets a server trace event that can be included in the event set.

AuditSchemaObjectTakeOwnershipEvent AuditSchemaObjectTakeOwnershipEvent AuditSchemaObjectTakeOwnershipEvent

Gets a server trace event that can be included in the event set.

AuditServerAlterTraceEvent AuditServerAlterTraceEvent AuditServerAlterTraceEvent

Gets a server trace event that can be included in the event set.

AuditServerObjectGdrEvent AuditServerObjectGdrEvent AuditServerObjectGdrEvent

Gets a server trace event that can be included in the event set.

AuditServerObjectManagementEvent AuditServerObjectManagementEvent AuditServerObjectManagementEvent

Gets a server trace event that can be included in the event set.

AuditServerObjectTakeOwnershipEvent AuditServerObjectTakeOwnershipEvent AuditServerObjectTakeOwnershipEvent

Gets a server trace event that can be included in the event set.

AuditServerOperationEvent AuditServerOperationEvent AuditServerOperationEvent

Gets a server trace event that can be included in the event set.

AuditServerPrincipalImpersonationEvent AuditServerPrincipalImpersonationEvent AuditServerPrincipalImpersonationEvent

Gets a server trace event that can be included in the event set.

AuditServerPrincipalManagementEvent AuditServerPrincipalManagementEvent AuditServerPrincipalManagementEvent

Gets a server trace event that can be included in the event set.

AuditServerScopeGdrEvent AuditServerScopeGdrEvent AuditServerScopeGdrEvent

Gets a server trace event that can be included in the event set.

BitmapWarning BitmapWarning BitmapWarning

Gets a server trace event that can be included in the event set.

BlockedProcessReport BlockedProcessReport BlockedProcessReport

Gets a server trace event that can be included in the event set.

CpuThresholdExceeded CpuThresholdExceeded CpuThresholdExceeded

Gets a server trace event that can be included in the event set.

DatabaseMirroringStateChange DatabaseMirroringStateChange DatabaseMirroringStateChange

Gets a server trace event that can be included in the event set.

DatabaseSuspectDataPage DatabaseSuspectDataPage DatabaseSuspectDataPage

Gets a server trace event that can be included in the event set.

DataFileAutoGrow DataFileAutoGrow DataFileAutoGrow

Gets a server trace event that can be included in the event set.

DataFileAutoShrink DataFileAutoShrink DataFileAutoShrink

Gets a server trace event that can be included in the event set.

DeadlockGraph DeadlockGraph DeadlockGraph

Gets a server trace event that can be included in the event set.

DeprecationAnnouncement DeprecationAnnouncement DeprecationAnnouncement

Gets a server trace event that can be included in the event set.

DeprecationFinalSupport DeprecationFinalSupport DeprecationFinalSupport

Gets a server trace event that can be included in the event set.

Errorlog Errorlog Errorlog

Gets a server trace event that can be included in the event set.

Eventlog Eventlog Eventlog

Gets a server trace event that can be included in the event set.

Exception Exception Exception

Gets a server trace event that can be included in the event set.

ExchangeSpillEvent ExchangeSpillEvent ExchangeSpillEvent

Gets a server trace event that can be included in the event set.

ExecutionWarnings ExecutionWarnings ExecutionWarnings

Gets a server trace event that can be included in the event set.

FtCrawlAborted FtCrawlAborted FtCrawlAborted

Gets a server trace event that can be included in the event set.

FtCrawlStarted FtCrawlStarted FtCrawlStarted

Gets a server trace event that can be included in the event set.

FtCrawlStopped FtCrawlStopped FtCrawlStopped

Gets a server trace event that can be included in the event set.

HashWarning HashWarning HashWarning

Gets a server trace event that can be included in the event set.

LockDeadlock LockDeadlock LockDeadlock

Gets a server event that can be included in the event set.

LockDeadlockChain LockDeadlockChain LockDeadlockChain

Gets a server trace event that can be included in the event set.

LockEscalation LockEscalation LockEscalation

Gets a server trace event that can be included in the event set.

LogFileAutoGrow LogFileAutoGrow LogFileAutoGrow

Gets a server trace event that can be included in the event set.

LogFileAutoShrink LogFileAutoShrink LogFileAutoShrink

Gets a server trace event that can be included in the event set.

MissingColumnStatistics MissingColumnStatistics MissingColumnStatistics

Gets a server trace event that can be included in the event set.

MissingJoinPredicate MissingJoinPredicate MissingJoinPredicate

Gets a server trace event that can be included in the event set.

MountTape MountTape MountTape

Gets a server trace event that can be included in the event set.

ObjectAltered ObjectAltered ObjectAltered

Gets a server trace event that can be included in the event set.

ObjectCreated ObjectCreated ObjectCreated

Gets a server trace event that can be included in the event set.

ObjectDeleted ObjectDeleted ObjectDeleted

Gets a server trace event that can be included in the event set.

OledbCallEvent OledbCallEvent OledbCallEvent

Gets a server trace event that can be included in the event set.

OledbDatareadEvent OledbDatareadEvent OledbDatareadEvent

Gets a server trace event that can be included in the event set.

OledbErrors OledbErrors OledbErrors

Gets a server trace event that can be included in the event set.

OledbProviderInformation OledbProviderInformation OledbProviderInformation

Gets a server trace event that can be included in the event set.

OledbQueryinterfaceEvent OledbQueryinterfaceEvent OledbQueryinterfaceEvent

Gets a server trace event that can be included in the event set.

Qn_dynamics Qn_dynamics Qn_dynamics

Gets a server trace event that can be included in the event set.

Qn_parameterTable Qn_parameterTable Qn_parameterTable

Gets a server trace event that can be included in the event set.

Qn_subscription Qn_subscription Qn_subscription

Gets a server trace event that can be included in the event set.

Qn_template Qn_template Qn_template

Gets a server trace event that can be included in the event set.

ServerMemoryChange ServerMemoryChange ServerMemoryChange

Gets a server trace event that can be included in the event set.

ShowplanAllForQueryCompile ShowplanAllForQueryCompile ShowplanAllForQueryCompile

Gets a server trace event that can be included in the event set.

ShowplanXml ShowplanXml ShowplanXml

Gets a server trace event that can be included in the event set.

ShowplanXmlForQueryCompile ShowplanXmlForQueryCompile ShowplanXmlForQueryCompile

Gets a server trace event that can be included in the event set.

ShowplanXmlStatisticsProfile ShowplanXmlStatisticsProfile ShowplanXmlStatisticsProfile

Gets a server trace event that can be included in the event set.

SortWarnings SortWarnings SortWarnings

Gets a server trace event that can be included in the event set.

SpCacheinsert SpCacheinsert SpCacheinsert

Gets a server trace event that can be included in the event set.

SpCachemiss SpCachemiss SpCachemiss

Gets a server trace event that can be included in the event set.

SpCacheremove SpCacheremove SpCacheremove

Gets a server trace event that can be included in the event set.

SpRecompile SpRecompile SpRecompile

Gets a server trace event that can be included in the event set.

SqlStmtrecompile SqlStmtrecompile SqlStmtrecompile

Gets a server trace event that can be included in the event set.

TraceAllEvents TraceAllEvents TraceAllEvents

Gets a server trace event category that can be included in the event set.

TraceClr TraceClr TraceClr

Gets a server trace event category that can be included in the event set.

TraceDatabase TraceDatabase TraceDatabase

Gets a server trace event category that can be included in the event set.

TraceDeprecation TraceDeprecation TraceDeprecation

Gets a server trace event category that can be included in the event set.

TraceErrorsAndWarnings TraceErrorsAndWarnings TraceErrorsAndWarnings

Gets a server trace event category that can be included in the event set.

TraceFileClose TraceFileClose TraceFileClose

Gets a server trace event category that can be included in the event set.

TraceFullText TraceFullText TraceFullText

Gets a server trace event category that can be included in the event set.

TraceLocks TraceLocks TraceLocks

Gets a server trace event category that can be included in the event set.

TraceObjects TraceObjects TraceObjects

Gets a server trace event that can be included in the event set.

TraceOledb TraceOledb TraceOledb

Gets a server trace event category that can be included in the event set.

TracePerformance TracePerformance TracePerformance

Gets a server trace event category that can be included in the event set.

TraceQueryNotifications TraceQueryNotifications TraceQueryNotifications

Gets a server trace event category that can be included in the event set.

TraceSecurityAudit TraceSecurityAudit TraceSecurityAudit

Gets a server trace event category that can be included in the event set.

TraceServer TraceServer TraceServer

Gets a server trace event category that can be included in the event set.

TraceStoredProcedures TraceStoredProcedures TraceStoredProcedures

Gets a server trace event category that can be included in the event set.

TraceTsql TraceTsql TraceTsql

Gets a server trace event that can be included in the event set.

TraceUserConfigurable TraceUserConfigurable TraceUserConfigurable

Gets a server trace event category that can be included in the event set.

Userconfigurable0 Userconfigurable0 Userconfigurable0

Gets a server trace event that can be included in the event set.

Userconfigurable1 Userconfigurable1 Userconfigurable1

Gets a server trace event that can be included in the event set.

Userconfigurable2 Userconfigurable2 Userconfigurable2

Gets a server trace event that can be included in the event set.

Userconfigurable3 Userconfigurable3 Userconfigurable3

Gets a server trace event that can be included in the event set.

Userconfigurable4 Userconfigurable4 Userconfigurable4

Gets a server trace event that can be included in the event set.

Userconfigurable5 Userconfigurable5 Userconfigurable5

Gets a server trace event that can be included in the event set.

Userconfigurable6 Userconfigurable6 Userconfigurable6

Gets a server trace event that can be included in the event set.

Userconfigurable7 Userconfigurable7 Userconfigurable7

Gets a server trace event that can be included in the event set.

Userconfigurable8 Userconfigurable8 Userconfigurable8

Gets a server trace event that can be included in the event set.

Userconfigurable9 Userconfigurable9 Userconfigurable9

Gets a server trace event that can be included in the event set.

UserErrorMessage UserErrorMessage UserErrorMessage

Gets a server trace event that can be included in the event set.

XqueryStaticType XqueryStaticType XqueryStaticType

Gets a server trace event that can be included in the event set.

Methods

Add(ServerTraceEvent, ServerTraceEvent) Add(ServerTraceEvent, ServerTraceEvent) Add(ServerTraceEvent, ServerTraceEvent)

Returns a server trace event set by adding two server trace events.

BitwiseOr(ServerTraceEvent, ServerTraceEvent) BitwiseOr(ServerTraceEvent, ServerTraceEvent) BitwiseOr(ServerTraceEvent, ServerTraceEvent)

Returns a new server trace event that includes both of the named Server Trace Events.

Equals(Object) Equals(Object) Equals(Object)

Determines whether the referenced server trace event object is equal to a specified object.

GetHashCode() GetHashCode() GetHashCode()

Identified for informational purposes only. Not supported. Future compatibility is not guaranteed.

ToString() ToString() ToString()

Returns the referenced object in string format.

Operators

Addition(ServerTraceEvent, ServerTraceEvent) Addition(ServerTraceEvent, ServerTraceEvent) Addition(ServerTraceEvent, ServerTraceEvent)

Creates a server trace event set by performing an addition operation on two server trace event objects.

BitwiseOr(ServerTraceEvent, ServerTraceEvent) BitwiseOr(ServerTraceEvent, ServerTraceEvent) BitwiseOr(ServerTraceEvent, ServerTraceEvent)

Creates a server trace event set by performing a bitwise OR operation on two ServerTraceEvent objects.

Equality(ServerTraceEvent, ServerTraceEvent) Equality(ServerTraceEvent, ServerTraceEvent) Equality(ServerTraceEvent, ServerTraceEvent)

Creates a server trace event set by comparing two ServerTraceEvent objects.

Implicit(ServerTraceEvent to ServerTraceEventSet) Implicit(ServerTraceEvent to ServerTraceEventSet) Implicit(ServerTraceEvent to ServerTraceEventSet)

Converts a single server trace event to a server trace event set.

Inequality(ServerTraceEvent, ServerTraceEvent) Inequality(ServerTraceEvent, ServerTraceEvent) Inequality(ServerTraceEvent, ServerTraceEvent)

Creates a server event set by comparing on two ServerTraceEvent objects.

Applies to