ServerTraceEvent Class

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

Inheritance Hierarchy

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

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public NotInheritable Class ServerTraceEvent
'Usage
Dim instance As ServerTraceEvent

public sealed class ServerTraceEvent

public ref class ServerTraceEvent sealed

[<SealedAttribute>]
type ServerTraceEvent =  class end

public final class ServerTraceEvent

The ServerTraceEvent type exposes the following members.

Properties

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

Top

Methods

	Name	Description
	Add	Returns a server trace event set by adding two server trace events.
	BitwiseOr	Returns a new server trace event that includes both of the named Server Trace Events.
	Equals	Determines whether the referenced server trace event object is equal to a specified object. (Overrides Object.Equals(Object).)
	Finalize	(Inherited from Object.)
	GetHashCode	Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. (Overrides Object.GetHashCode().)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	ToString	Returns the referenced object in string format. (Overrides Object.ToString().)

Top

Operators

	Name	Description
	Addition	Creates a server trace event set by performing an addition operation on two server trace event objects.
	BitwiseOr	Creates a server trace event set by performing a bitwise OR operation on two ServerTraceEvent objects.
	Equality	Creates a server trace event set by comparing two ServerTraceEvent objects.
	Implicit(ServerTraceEvent to ServerTraceEventSet)	Converts a single server trace event to a server trace event set.
	Inequality	Creates a server event set by comparing on two ServerTraceEvent objects.

Top

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.

Examples

Handling SMO Events

Thread Safety

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

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Handling SMO Events