Udostępnij przez

ServerTraceEvent Members

The ServerTraceEvent object represents the 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(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AssemblyLoad Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditAddDBUserEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditAddloginEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditAddLoginToServerRoleEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditAddMemberToDBRoleEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditAddRoleEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditAppRoleChangePasswordEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditBackupRestoreEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditChangeAuditEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditChangeDatabaseOwner Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditDatabaseManagementEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditDatabaseObjectAccessEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditDatabaseObjectGdrEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditDatabaseObjectManagementEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditDatabaseObjectTakeOwnershipEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditDatabaseOperationEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditDatabasePrincipalImpersonationEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditDatabasePrincipalManagementEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditDatabaseScopeGdrEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditDbccEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditFulltext  
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditLogin Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditLoginChangePasswordEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditLoginChangePropertyEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditLoginFailed Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditLoginGdrEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditLogout Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditSchemaObjectAccessEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditSchemaObjectGdrEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditSchemaObjectManagementEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditSchemaObjectTakeOwnershipEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditServerAlterTraceEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditServerObjectGdrEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditServerObjectManagementEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditServerObjectTakeOwnershipEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditServerOperationEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditServerPrincipalImpersonationEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditServerPrincipalManagementEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif AuditServerScopeGdrEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif BitmapWarning Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif BlockedProcessReport Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif CpuThresholdExceeded Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif DatabaseMirroringStateChange Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif DatabaseSuspectDataPage Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif DataFileAutoGrow Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif DataFileAutoShrink Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif DeadlockGraph Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif DeprecationAnnouncement Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif DeprecationFinalSupport Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Errorlog Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Eventlog Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Exception Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif ExchangeSpillEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif ExecutionWarnings Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif FtCrawlAborted Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif FtCrawlStarted Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif FtCrawlStopped Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif HashWarning Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif LockDeadlock Gets a server event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif LockDeadlockChain Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif LockEscalation Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif LogFileAutoGrow Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif LogFileAutoShrink Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif MissingColumnStatistics Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif MissingJoinPredicate Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif MountTape Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif ObjectAltered Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif ObjectCreated Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif ObjectDeleted Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif OledbCallEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif OledbDatareadEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif OledbErrors Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif OledbProviderInformation Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif OledbQueryinterfaceEvent Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Qn_dynamics Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Qn_parameterTable Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Qn_subscription Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Qn_template Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif ServerMemoryChange Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif ShowplanAllForQueryCompile Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif ShowplanXml Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif ShowplanXmlForQueryCompile Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif ShowplanXmlStatisticsProfile Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif SortWarnings Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif SpCacheinsert Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif SpCachemiss Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif SpCacheremove Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif SpRecompile Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif SqlStmtrecompile Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceAllEvents Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceClr Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceDatabase Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceDeprecation Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceErrorsAndWarnings Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceFileClose Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceFullText Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceLocks Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceObjects Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceOledb Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TracePerformance Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceQueryNotifications Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceSecurityAudit Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceServer Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceStoredProcedures Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceTsql Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif TraceUserConfigurable Gets a server trace event category that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Userconfigurable0 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Userconfigurable1 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Userconfigurable2 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Userconfigurable3 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Userconfigurable4 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Userconfigurable5 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Userconfigurable6 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Userconfigurable7 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Userconfigurable8 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Userconfigurable9 Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif UserErrorMessage Gets a server trace event that can be included in the event set.
ms220309.pubproperty(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).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(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif Add Returns a server trace event set by adding two server trace events.
ms220309.pubmethod(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif BitwiseOr Returns a new server trace event that includes both of the named Server Trace Events.
ms220309.pubmethod(pl-pl,SQL.100).gif Equals Overloaded. Overridden. Determines if two Server Trace Events are equal.
ms220309.pubmethod(pl-pl,SQL.100).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(pl-pl,SQL.100).gif GetType  (inherited from Object )
ms220309.pubmethod(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif op_Addition Creates a server trace event set by performing an addition operation on two server trace event objects.
ms220309.pubmethod(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif op_BitwiseOr Creates a server trace event set by performing a bitwise OR operation on two ServerTraceEvent objects.
ms220309.pubmethod(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif op_Equality Creates a server trace event set by comparing two ServerTraceEvent objects.
ms220309.pubmethod(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif op_Implicit  
ms220309.pubmethod(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif op_Inequality Creates a server event set by comparing on two ServerTraceEvent objects.
ms220309.pubmethod(pl-pl,SQL.100).gifms220309.static(pl-pl,SQL.100).gif ReferenceEquals  (inherited from Object )
ms220309.pubmethod(pl-pl,SQL.100).gif ToString Overridden. Returns the referenced object in string format.

Top

Protected Methods

  Name Description
ms220309.protmethod(pl-pl,SQL.100).gif Finalize  (inherited from Object )
ms220309.protmethod(pl-pl,SQL.100).gif MemberwiseClone  (inherited from Object )

Top

  • Last updated on