Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

ServerTraceEventSet Class

 

Applies To: SQL Server 2016 Preview

The ServerTraceEventSet object represents a set server trace events.

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

System.Object
  Microsoft.SqlServer.Management.Smo.EventSetBase
    Microsoft.SqlServer.Management.Smo.ServerTraceEventSet

public sealed class ServerTraceEventSet : EventSetBase

NameDescription
System_CAPS_pubmethodServerTraceEventSet()

Initializes a new instance of the ServerTraceEventSet class.

System_CAPS_pubmethodServerTraceEventSet(ServerTraceEvent)

Initializes a new instance of the ServerTraceEventSet class with a specified event.

System_CAPS_pubmethodServerTraceEventSet(ServerTraceEvent[])

Initializes a new instance of the ServerTraceEventSet class with the specified set of events.

System_CAPS_pubmethodServerTraceEventSet(ServerTraceEventSet)

Initializes a new instance of the ServerTraceEventSet class with the specified set of events.

NameDescription
System_CAPS_pubpropertyAssemblyLoad

Gets or sets a boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAuditAddDBUserEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAuditAddloginEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a new login is added.

System_CAPS_pubpropertyAuditAddLoginToServerRoleEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a login is added to a server role.

System_CAPS_pubpropertyAuditAddMemberToDBRoleEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a new member is added to a database role.

System_CAPS_pubpropertyAuditAddRoleEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a new role is added.

System_CAPS_pubpropertyAuditAppRoleChangePasswordEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the password for an application role is changed.

System_CAPS_pubpropertyAuditBackupRestoreEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a backup and restore operation is issued.

System_CAPS_pubpropertyAuditChangeAuditEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when audit trace modifications are made.

System_CAPS_pubpropertyAuditChangeDatabaseOwner

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the database owner is changed.

System_CAPS_pubpropertyAuditDatabaseManagementEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database is created, altered, or dropped.

System_CAPS_pubpropertyAuditDatabaseObjectAccessEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database object is accessed, such as a schema.

System_CAPS_pubpropertyAuditDatabaseObjectGdrEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when grant, deny, or revoke operation is issued on a database object, such as a schema.

System_CAPS_pubpropertyAuditDatabaseObjectManagementEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database object is created, altered or dropped.

System_CAPS_pubpropertyAuditDatabaseObjectTakeOwnershipEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when ownership of an object in the database scope is changed.

System_CAPS_pubpropertyAuditDatabaseOperationEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a database operation occurs, such as a checkpoint.

System_CAPS_pubpropertyAuditDatabasePrincipalImpersonationEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when there is an impersonation within the scope of the database, such as a SETUSER or an EXECUTE AS USER.

System_CAPS_pubpropertyAuditDatabasePrincipalManagementEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a principal, such as users, are created, altered, or dropped from the database.

System_CAPS_pubpropertyAuditDatabaseScopeGdrEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a grant, deny, or revoke operation is issued within the scope of the database.

System_CAPS_pubpropertyAuditDbccEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when DBCC commands are issued.

System_CAPS_pubpropertyAuditFulltext

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyAuditLogin

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user successfully logs on to Microsoft SQL Server.

System_CAPS_pubpropertyAuditLoginChangePasswordEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a SQL Server login password is changed.

System_CAPS_pubpropertyAuditLoginChangePropertyEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a login property, other than password, is changed.

System_CAPS_pubpropertyAuditLoginFailed

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an attempt to log in to SQL Server fails.

System_CAPS_pubpropertyAuditLoginGdrEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a grant, deny, or revoke operation is issued on a login object.

System_CAPS_pubpropertyAuditLogout

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a user successfully logs out of SQL Server.

System_CAPS_pubpropertyAuditSchemaObjectAccessEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an object permission, such as SELECT, is used both successfully or unsuccessfully.

System_CAPS_pubpropertyAuditSchemaObjectGdrEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an object grant, deny, or revoke operation is issued.

System_CAPS_pubpropertyAuditSchemaObjectManagementEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an object is created, altered or dropped.

System_CAPS_pubpropertyAuditSchemaObjectTakeOwnershipEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an ALTER AUTHORIZATION command is used to change the owner of an object.

System_CAPS_pubpropertyAuditServerAlterTraceEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a statement checks for the ALTER TRACE permission.

System_CAPS_pubpropertyAuditServerObjectGdrEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a grant, deny, or revoke operation is issued on a schema object, such as a table or a function.

System_CAPS_pubpropertyAuditServerObjectManagementEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a server objects are created, altered, or dropped.

System_CAPS_pubpropertyAuditServerObjectTakeOwnershipEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the ownership is changed for objects within the scope of the server.

System_CAPS_pubpropertyAuditServerOperationEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when Security Audit operations such as altering settings, resources, external access, or authorization are used.

System_CAPS_pubpropertyAuditServerPrincipalImpersonationEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when there is an impersonation within scope of the server, such as EXECUTE AS LOGIN.

System_CAPS_pubpropertyAuditServerPrincipalManagementEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a server principals are created, altered, or dropped.

System_CAPS_pubpropertyAuditServerScopeGdrEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a grant, deny, or revoke operation for permissions is issued in the scope of the server, such as creating a login.

System_CAPS_pubpropertyBitmapWarning

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyBlockedProcessReport

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a process has been blocked for more than a specified amount of time.

System_CAPS_pubpropertyCpuThresholdExceeded

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDatabaseMirroringStateChange

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when the state of a mirrored database changes.

System_CAPS_pubpropertyDatabaseSuspectDataPage

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyDataFileAutoGrow

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a data file is extended automatically by the server.

System_CAPS_pubpropertyDataFileAutoShrink

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a data file is reduced automatically by the server.

System_CAPS_pubpropertyDeadlockGraph

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an attempt to acquire a lock is canceled because the attempt was part of a deadlock and was chosen as the deadlock victim.

System_CAPS_pubpropertyDeprecationAnnouncement

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a feature is used that will be removed from a future version of SQL Server.

System_CAPS_pubpropertyDeprecationFinalSupport

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a feature is used that will be removed from the next major version of SQL Server.

System_CAPS_pubpropertyErrorlog

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when error events are logged in the SQL Server error log.

System_CAPS_pubpropertyEventlog

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when error events are logged in the SQL Server application.

System_CAPS_pubpropertyException

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an exception occurs in SQL Server

System_CAPS_pubpropertyExchangeSpillEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when communication buffers in a parallel query plan have been temporarily written to the tempdb database.

System_CAPS_pubpropertyExecutionWarnings

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when warnings are issued during the execution of a SQL Server statement or stored procedure.

System_CAPS_pubpropertyFtCrawlAborted

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an exception is encountered during a full-text crawl.

System_CAPS_pubpropertyFtCrawlStarted

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text crawl (population) starts.

System_CAPS_pubpropertyFtCrawlStopped

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a full-text crawl (population) starts.

System_CAPS_pubpropertyHashWarning

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a hashing operation that is not processing on a buffer partition has reverted to an alternate plan.

System_CAPS_pubpropertyLockDeadlock

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when two concurrent transactions have deadlocked each other by trying to obtain incompatible locks on resources that the other transaction owns.

System_CAPS_pubpropertyLockDeadlockChain

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs for each of the events leading up to a deadlock.

System_CAPS_pubpropertyLockEscalation

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a fine-grained lock has been converted to a coarse-grained lock (for example, a page lock escalated or converted to a table lock).

System_CAPS_pubpropertyLogFileAutoGrow

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a log file was extended automatically by the server.

System_CAPS_pubpropertyLogFileAutoShrink

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a log file was reduced automatically by the server.

System_CAPS_pubpropertyMissingColumnStatistics

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when column statistics that would be useful for the optimizer are not available.

System_CAPS_pubpropertyMissingJoinPredicate

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a query that has no join predicate is being executed.

System_CAPS_pubpropertyMountTape

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a request to mount a tape is received.

System_CAPS_pubpropertyNumberOfElements

Gets the number of elements in the event set.(Overrides EventSetBase.NumberOfElements.)

System_CAPS_pubpropertyObjectAltered

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an object is altered.

System_CAPS_pubpropertyObjectCreated

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an object is created.

System_CAPS_pubpropertyObjectDeleted

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an object is deleted.

System_CAPS_pubpropertyOledbCallEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyOledbDatareadEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyOledbErrors

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an OLE DB error occurs.

System_CAPS_pubpropertyOledbProviderInformation

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyOledbQueryinterfaceEvent

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyQn_dynamics

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyQn_parameterTable

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyQn_subscription

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyQn_template

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyServerMemoryChange

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when SQL Server memory usage has increased or decreased by either 1 MB or 5 percent of the maximum server memory, whichever is greater.

System_CAPS_pubpropertyShowplanAllForQueryCompile

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an SQL statement compiles and displays complete, compile-time data.

System_CAPS_pubpropertyShowplanXml

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyShowplanXmlForQueryCompile

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an SQL statement executes and displays the complete, compile-time data.

System_CAPS_pubpropertyShowplanXmlStatisticsProfile

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertySortWarnings

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a sort warning is generated.

System_CAPS_pubpropertySpCacheinsert

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an item is inserted into the procedure cache.

System_CAPS_pubpropertySpCachemiss

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a procedure is not found in the procedure cache.

System_CAPS_pubpropertySpCacheremove

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when an item is removed from the procedure cache.

System_CAPS_pubpropertySpRecompile

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs when a procedure is recompiled.

System_CAPS_pubpropertySqlStmtrecompile

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_protpropertyStorage

Gets or sets the bit array for event set storage. (Inherited from EventSetBase.)

System_CAPS_pubpropertyTraceAllEvents

Gets or sets a Boolean property value that specifies whether all events are included in the trace or not.

System_CAPS_pubpropertyTraceClr

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyTraceDatabase

Gets or sets a Boolean property value that specifies whether the Database category events are recorded in the trace.

System_CAPS_pubpropertyTraceDeprecation

Gets or sets a Boolean property value that specifies whether Deprecation category events are recorded in the trace.

System_CAPS_pubpropertyTraceErrorsAndWarnings

Gets or sets a Boolean property value that specifies whether errors and warnings are recorded in the trace.

System_CAPS_pubpropertyTraceFileClose

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event occurs if a trace file closes when a transaction is rolled back.

System_CAPS_pubpropertyTraceFullText

Gets or sets a Boolean property value that specifies whether Full Text category events are recorded in the trace.

System_CAPS_pubpropertyTraceLocks

Gets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.

System_CAPS_pubpropertyTraceObjects

Gets or sets a Boolean property value that specifies whether Object category events are recorded in the trace.

System_CAPS_pubpropertyTraceOledb

Gets or sets a Boolean property value that specifies whether OLE DB category events are recorded in the trace.

System_CAPS_pubpropertyTracePerformance

Gets or sets a Boolean property value that specifies whether Performance category events are recorded in the trace.

System_CAPS_pubpropertyTraceQueryNotifications

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

System_CAPS_pubpropertyTraceSecurityAudit

Gets or sets a Boolean property value that specifies whether Security Audit category events are recorded in the trace.

System_CAPS_pubpropertyTraceServer

Gets or sets a Boolean property value that specifies whether Server category events are recorded in the trace.

System_CAPS_pubpropertyTraceStoredProcedures

Gets or sets a Boolean property value that specifies whether Stored Procedure category events are recorded in the trace.

System_CAPS_pubpropertyTraceTsql

Gets or sets a Boolean property value that specifies whether Transact-SQL category events are recorded in the trace.

System_CAPS_pubpropertyTraceUserConfigurable

Gets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.

System_CAPS_pubpropertyUserconfigurable0

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.

System_CAPS_pubpropertyUserconfigurable1

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.

System_CAPS_pubpropertyUserconfigurable2

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.

System_CAPS_pubpropertyUserconfigurable3

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.

System_CAPS_pubpropertyUserconfigurable4

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.

System_CAPS_pubpropertyUserconfigurable5

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.

System_CAPS_pubpropertyUserconfigurable6

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.

System_CAPS_pubpropertyUserconfigurable7

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.

System_CAPS_pubpropertyUserconfigurable8

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.

System_CAPS_pubpropertyUserconfigurable9

Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.

System_CAPS_pubpropertyUserErrorMessage

Gets or sets a Boolean value that specifies whether the UserErrorMessage event is included in the event set.

System_CAPS_pubpropertyXqueryStaticType

Gets or sets a Boolean property value that specifies whether the event is included in the event set.

NameDescription
System_CAPS_pubmethodAdd(ServerTraceEvent)

Returns a trace event set after adding a trace event to an existing event set.

System_CAPS_pubmethodSystem_CAPS_staticAdd(ServerTraceEventSet, ServerTraceEvent)

Returns a trace event set after adding a trace event to an existing event set.

System_CAPS_pubmethodCopy()

Returns a copy of the event set.(Overrides EventSetBase.Copy().)

System_CAPS_pubmethodEquals(Object)

(Inherited from Object.)

System_CAPS_pubmethodGetHashCode()

(Inherited from Object.)

System_CAPS_pubmethodGetType()

(Inherited from Object.)

System_CAPS_pubmethodRemove(ServerTraceEvent)

Removes an event from the event set.

System_CAPS_pubmethodSystem_CAPS_staticSubtract(ServerTraceEventSet, ServerTraceEvent)

Returns a trace event set after subtracting a trace event from an existing event set.

System_CAPS_pubmethodToString()

Returns a string that represents the ServerTraceEventSet object.(Overrides Object.ToString().)

NameDescription
System_CAPS_puboperatorSystem_CAPS_staticAddition(ServerTraceEventSet, ServerTraceEvent)

Creates a server trace event set by performing an addition operation on a ServerTraceEvent object and a ServerTraceEventSet object.

System_CAPS_puboperatorSystem_CAPS_staticSubtraction(ServerTraceEventSet, ServerTraceEvent)

Creates a server trace event set by performing a subtraction operation on a ServerTraceEvent object and a ServerTraceEventSet object.

The ServerTraceEventSet object contains a property for each event to which the server trace responds. The events fall into categories, which are described in SQL Server Event Class Reference. The ServerTraceEventSet class is used to define a set of events that can be traced by SQL Server Profiler or the SMO Trace objects.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

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.

Legacy Code Example

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

Return to top

Community Additions

Show:
© 2015 Microsoft