ServerTraceEvent Members

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

	이름	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
	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.
	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.
	BlockedProcessReport	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.
	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
	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.
	TraceBroker	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.
	TraceCursors	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.
	TraceProgressReport	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.
	TraceScans	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.
	TraceServerInternalDiagnostics	Gets a server trace event category that can be included in the event set.
	TraceSessions	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.
	TraceTransactions	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.

위쪽

Public Methods

(see also Protected Methods )

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

위쪽

Protected Methods

	이름	Description
	Finalize	(inherited from Object )
	MemberwiseClone	(inherited from Object )

위쪽

참고 항목

참조

ServerTraceEvent Class
Microsoft.SqlServer.Management.Smo Namespace

관련 자료

Handling SMO Events
이벤트 알림용 추적 이벤트