Share via

ServerTraceEvent Members

  • Article

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

The following tables list the members exposed by the ServerTraceEvent type.

Public Properties

  Name Description
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AssemblyLoad Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditAddDBUserEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditAddloginEvent  
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditAddLoginToServerRoleEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditAddMemberToDBRoleEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditAddRoleEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditAppRoleChangePasswordEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditBackupRestoreEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditChangeAuditEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditChangeDatabaseOwner Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditDatabaseManagementEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditDatabaseObjectAccessEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditDatabaseObjectGdrEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditDatabaseObjectManagementEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditDatabaseObjectTakeOwnershipEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditDatabaseOperationEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditDatabasePrincipalImpersonationEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditDatabasePrincipalManagementEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditDatabaseScopeGdrEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditDbccEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditLogin Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditLoginChangePasswordEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditLoginChangePropertyEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditLoginFailed Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditLoginGdrEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditLogout Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditSchemaObjectAccessEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditSchemaObjectGdrEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditSchemaObjectManagementEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditSchemaObjectTakeOwnershipEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditServerAlterTraceEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditServerObjectGdrEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditServerObjectManagementEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditServerObjectTakeOwnershipEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditServerOperationEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditServerPrincipalImpersonationEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditServerPrincipalManagementEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif AuditServerScopeGdrEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif BlockedProcessReport Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif DatabaseMirroringStateChange Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif DataFileAutoGrow Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif DataFileAutoShrink Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif DeadlockGraph Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif DeprecationAnnouncement Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif DeprecationFinalSupport Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Errorlog Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Eventlog Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Exception Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif ExchangeSpillEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif ExecutionWarnings Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif FtCrawlAborted Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif FtCrawlStarted Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif FtCrawlStopped Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif HashWarning Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif LockDeadlock Gets a server event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif LockDeadlockChain Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif LockEscalation Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif LogFileAutoGrow Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif LogFileAutoShrink Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif MissingColumnStatistics Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif MissingJoinPredicate Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif MountTape Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif ObjectAltered Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif ObjectCreated Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif ObjectDeleted Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif OledbCallEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif OledbDatareadEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif OledbErrors Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif OledbProviderInformation Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif OledbQueryinterfaceEvent  
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Qn_dynamics Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Qn_parameterTable Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Qn_subscription Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Qn_template Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif ServerMemoryChange Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif ShowplanAllForQueryCompile Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif ShowplanXml Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif ShowplanXmlForQueryCompile Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif ShowplanXmlStatisticsProfile Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif SortWarnings Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif SpCacheinsert Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif SpCachemiss Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif SpCacheremove Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif SpRecompile Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif SqlStmtrecompile Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceAllEvents Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceBroker Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceClr Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceCursors Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceDatabase Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceDeprecation Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceErrorsAndWarnings Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceFileClose Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceFullText Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceLocks Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceObjects Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceOledb Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TracePerformance Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceProgressReport Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceQueryNotifications Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceScans Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceSecurityAudit Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceServer Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceServerInternalDiagnostics Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceSessions Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceStoredProcedures Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceTransactions Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceTsql Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif TraceUserConfigurable Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Userconfigurable0 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Userconfigurable1 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Userconfigurable2 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Userconfigurable3 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Userconfigurable4 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Userconfigurable5 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Userconfigurable6 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Userconfigurable7 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Userconfigurable8 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Userconfigurable9 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif UserErrorMessage Gets a server trace event that can be included in the event set.
ms220309.pubproperty(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif XqueryStaticType Gets a server trace event that can be included in the event set.

Top

Public Methods

(see also Protected Methods )

  Name Description
ms220309.pubmethod(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif Add Returns a server trace event set by adding two server trace events.
ms220309.pubmethod(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif BitwiseOr  
ms220309.pubmethod(en-US,SQL.90).gif Equals Overloaded. Overridden.  
ms220309.pubmethod(en-US,SQL.90).gif GetHashCode Overridden. This method supports the Microsoft SQL Server 2005 infrastructure and is not intended to be used directly from your code.
ms220309.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms220309.pubmethod(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif op_Addition  
ms220309.pubmethod(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif op_BitwiseOr Creates a server trace event set by performing a bitwise OR operation on two ServerTraceEvent objects.
ms220309.pubmethod(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif op_Equality Creates a server trace event set by comparing two ServerTraceEvent objects.
ms220309.pubmethod(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif op_Implicit  
ms220309.pubmethod(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif op_Inequality Creates a server event set by comparing on two ServerTraceEvent objects.
ms220309.pubmethod(en-US,SQL.90).gifms220309.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms220309.pubmethod(en-US,SQL.90).gif ToString Overridden. Returns the referenced object in string format.

Top

Protected Methods

  Name Description
ms220309.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms220309.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

ServerTraceEvent Class
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Handling SMO Events
Trace Events for Use with Event Notifications