Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ServerTraceEvent Class

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

System.Object
  Microsoft.SqlServer.Management.Smo.ServerTraceEvent

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
public sealed class ServerTraceEvent

The ServerTraceEvent type exposes the following members.

  NameDescription
Public propertyStatic memberAssemblyLoadGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditAddDBUserEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditAddloginEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditAddLoginToServerRoleEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditAddMemberToDBRoleEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditAddRoleEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditAppRoleChangePasswordEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditBackupRestoreEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditChangeAuditEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditChangeDatabaseOwnerGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditDatabaseManagementEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditDatabaseObjectAccessEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditDatabaseObjectGdrEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditDatabaseObjectManagementEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditDatabaseObjectTakeOwnershipEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditDatabaseOperationEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditDatabasePrincipalImpersonationEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditDatabasePrincipalManagementEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditDatabaseScopeGdrEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditDbccEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditFulltextGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditLoginGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditLoginChangePasswordEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditLoginChangePropertyEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditLoginFailedGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditLoginGdrEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditLogoutGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditSchemaObjectAccessEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditSchemaObjectGdrEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditSchemaObjectManagementEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditSchemaObjectTakeOwnershipEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditServerAlterTraceEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditServerObjectGdrEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditServerObjectManagementEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditServerObjectTakeOwnershipEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditServerOperationEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditServerPrincipalImpersonationEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditServerPrincipalManagementEventGets a server trace event that can be included in the event set.
Public propertyStatic memberAuditServerScopeGdrEventGets a server trace event that can be included in the event set.
Public propertyStatic memberBitmapWarningGets a server trace event that can be included in the event set.
Public propertyStatic memberBlockedProcessReportGets a server trace event that can be included in the event set.
Public propertyStatic memberCpuThresholdExceededGets a server trace event that can be included in the event set.
Public propertyStatic memberDatabaseMirroringStateChangeGets a server trace event that can be included in the event set.
Public propertyStatic memberDatabaseSuspectDataPageGets a server trace event that can be included in the event set.
Public propertyStatic memberDataFileAutoGrowGets a server trace event that can be included in the event set.
Public propertyStatic memberDataFileAutoShrinkGets a server trace event that can be included in the event set.
Public propertyStatic memberDeadlockGraphGets a server trace event that can be included in the event set.
Public propertyStatic memberDeprecationAnnouncementGets a server trace event that can be included in the event set.
Public propertyStatic memberDeprecationFinalSupportGets a server trace event that can be included in the event set.
Public propertyStatic memberErrorlogGets a server trace event that can be included in the event set.
Public propertyStatic memberEventlogGets a server trace event that can be included in the event set.
Public propertyStatic memberExceptionGets a server trace event that can be included in the event set.
Public propertyStatic memberExchangeSpillEventGets a server trace event that can be included in the event set.
Public propertyStatic memberExecutionWarningsGets a server trace event that can be included in the event set.
Public propertyStatic memberFtCrawlAbortedGets a server trace event that can be included in the event set.
Public propertyStatic memberFtCrawlStartedGets a server trace event that can be included in the event set.
Public propertyStatic memberFtCrawlStoppedGets a server trace event that can be included in the event set.
Public propertyStatic memberHashWarningGets a server trace event that can be included in the event set.
Public propertyStatic memberLockDeadlockGets a server event that can be included in the event set.
Public propertyStatic memberLockDeadlockChainGets a server trace event that can be included in the event set.
Public propertyStatic memberLockEscalationGets a server trace event that can be included in the event set.
Public propertyStatic memberLogFileAutoGrowGets a server trace event that can be included in the event set.
Public propertyStatic memberLogFileAutoShrinkGets a server trace event that can be included in the event set.
Public propertyStatic memberMissingColumnStatisticsGets a server trace event that can be included in the event set.
Public propertyStatic memberMissingJoinPredicateGets a server trace event that can be included in the event set.
Public propertyStatic memberMountTapeGets a server trace event that can be included in the event set.
Public propertyStatic memberObjectAlteredGets a server trace event that can be included in the event set.
Public propertyStatic memberObjectCreatedGets a server trace event that can be included in the event set.
Public propertyStatic memberObjectDeletedGets a server trace event that can be included in the event set.
Public propertyStatic memberOledbCallEventGets a server trace event that can be included in the event set.
Public propertyStatic memberOledbDatareadEventGets a server trace event that can be included in the event set.
Public propertyStatic memberOledbErrorsGets a server trace event that can be included in the event set.
Public propertyStatic memberOledbProviderInformationGets a server trace event that can be included in the event set.
Public propertyStatic memberOledbQueryinterfaceEventGets a server trace event that can be included in the event set.
Public propertyStatic memberQn_dynamicsGets a server trace event that can be included in the event set.
Public propertyStatic memberQn_parameterTableGets a server trace event that can be included in the event set.
Public propertyStatic memberQn_subscriptionGets a server trace event that can be included in the event set.
Public propertyStatic memberQn_templateGets a server trace event that can be included in the event set.
Public propertyStatic memberServerMemoryChangeGets a server trace event that can be included in the event set.
Public propertyStatic memberShowplanAllForQueryCompileGets a server trace event that can be included in the event set.
Public propertyStatic memberShowplanXmlGets a server trace event that can be included in the event set.
Public propertyStatic memberShowplanXmlForQueryCompileGets a server trace event that can be included in the event set.
Public propertyStatic memberShowplanXmlStatisticsProfileGets a server trace event that can be included in the event set.
Public propertyStatic memberSortWarningsGets a server trace event that can be included in the event set.
Public propertyStatic memberSpCacheinsertGets a server trace event that can be included in the event set.
Public propertyStatic memberSpCachemissGets a server trace event that can be included in the event set.
Public propertyStatic memberSpCacheremoveGets a server trace event that can be included in the event set.
Public propertyStatic memberSpRecompileGets a server trace event that can be included in the event set.
Public propertyStatic memberSqlStmtrecompileGets a server trace event that can be included in the event set.
Public propertyStatic memberTraceAllEventsGets a server trace event category that can be included in the event set.
Public propertyStatic memberTraceClrGets a server trace event category that can be included in the event set.
Public propertyStatic memberTraceDatabaseGets a server trace event category that can be included in the event set.
Public propertyStatic memberTraceDeprecationGets a server trace event category that can be included in the event set.
Public propertyStatic memberTraceErrorsAndWarningsGets a server trace event category that can be included in the event set.
Public propertyStatic memberTraceFileCloseGets a server trace event category that can be included in the event set.
Public propertyStatic memberTraceFullTextGets a server trace event category that can be included in the event set.
Public propertyStatic memberTraceLocksGets a server trace event category that can be included in the event set.
Public propertyStatic memberTraceObjectsGets a server trace event that can be included in the event set.
Public propertyStatic memberTraceOledbGets a server trace event category that can be included in the event set.
Public propertyStatic memberTracePerformanceGets a server trace event category that can be included in the event set.
Public propertyStatic memberTraceQueryNotificationsGets a server trace event category that can be included in the event set.
Public propertyStatic memberTraceSecurityAuditGets a server trace event category that can be included in the event set.
Public propertyStatic memberTraceServerGets a server trace event category that can be included in the event set.
Public propertyStatic memberTraceStoredProceduresGets a server trace event category that can be included in the event set.
Public propertyStatic memberTraceTsqlGets a server trace event that can be included in the event set.
Public propertyStatic memberTraceUserConfigurableGets a server trace event category that can be included in the event set.
Public propertyStatic memberUserconfigurable0Gets a server trace event that can be included in the event set.
Public propertyStatic memberUserconfigurable1Gets a server trace event that can be included in the event set.
Public propertyStatic memberUserconfigurable2Gets a server trace event that can be included in the event set.
Public propertyStatic memberUserconfigurable3Gets a server trace event that can be included in the event set.
Public propertyStatic memberUserconfigurable4Gets a server trace event that can be included in the event set.
Public propertyStatic memberUserconfigurable5Gets a server trace event that can be included in the event set.
Public propertyStatic memberUserconfigurable6Gets a server trace event that can be included in the event set.
Public propertyStatic memberUserconfigurable7Gets a server trace event that can be included in the event set.
Public propertyStatic memberUserconfigurable8Gets a server trace event that can be included in the event set.
Public propertyStatic memberUserconfigurable9Gets a server trace event that can be included in the event set.
Public propertyStatic memberUserErrorMessageGets a server trace event that can be included in the event set.
Public propertyStatic memberXqueryStaticTypeGets a server trace event that can be included in the event set.
Top
  NameDescription
Public methodStatic memberAddReturns a server trace event set by adding two server trace events.
Public methodStatic memberBitwiseOrReturns a new server trace event that includes both of the named Server Trace Events.
Public methodEqualsDetermines whether the referenced server trace event object is equal to a specified object. (Overrides Object.Equals(Object).)
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCodeIdentified for informational purposes only. Not supported. Future compatibility is not guaranteed. (Overrides Object.GetHashCode().)
Public methodGetType (Inherited from Object.)
Protected methodMemberwiseClone (Inherited from Object.)
Public methodToStringReturns the referenced object in string format. (Overrides Object.ToString().)
Top
  NameDescription
Public operatorStatic memberAdditionCreates a server trace event set by performing an addition operation on two server trace event objects.
Public operatorStatic memberBitwiseOrCreates a server trace event set by performing a bitwise OR operation on two ServerTraceEvent objects.
Public operatorStatic memberEqualityCreates a server trace event set by comparing two ServerTraceEvent objects.
Public operatorStatic memberImplicit(ServerTraceEvent to ServerTraceEventSet)Converts a single server trace event to a server trace event set.
Public operatorStatic memberInequalityCreates a server event set by comparing on two ServerTraceEvent objects.
Top

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.