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 | |
|---|---|---|
.gif "Public property") .gif "Static member") |
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 | |
|---|---|---|
.gif "Public method") |
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).) |
|
GetHashCode | Identified for informational purposes only. Not supported. Future compatibility is not guaranteed. (Overrides Object.GetHashCode().) |
|
GetType | (Inherited from Object.) |
|
ToString | Returns the referenced object in string format. (Overrides Object.ToString().) |
Top
Operators
| Name | Description | |
|---|---|---|
.gif "Public operator") |
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
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