Export (0) Print
Expand All

ServerTraceEventSet Class

The ServerTraceEventSet object represents a set server trace events.

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

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

public final class ServerTraceEventSet extends EventSetBase

The ServerTraceEventSet type exposes the following members.

  NameDescription
Public methodServerTraceEventSet()Initializes a new instance of the ServerTraceEventSet class.
Public methodServerTraceEventSet(ServerTraceEvent)Initializes a new instance of the ServerTraceEventSet class with a specified event.
Public methodServerTraceEventSet(ServerTraceEvent[])Initializes a new instance of the ServerTraceEventSet class with the specified set of events.
Public methodServerTraceEventSet(ServerTraceEventSet)Initializes a new instance of the ServerTraceEventSet class with the specified set of events.
Top

  NameDescription
Public propertyAssemblyLoadGets or sets a boolean property value that specifies whether the event is included in the event set.
Public propertyAuditAddDBUserEventGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAuditAddloginEventGets 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.
Public propertyAuditAddLoginToServerRoleEventGets 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.
Public propertyAuditAddMemberToDBRoleEventGets 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.
Public propertyAuditAddRoleEventGets 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.
Public propertyAuditAppRoleChangePasswordEventGets 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.
Public propertyAuditBackupRestoreEventGets 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.
Public propertyAuditChangeAuditEventGets 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.
Public propertyAuditChangeDatabaseOwnerGets 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.
Public propertyAuditDatabaseManagementEventGets 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.
Public propertyAuditDatabaseObjectAccessEventGets 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.
Public propertyAuditDatabaseObjectGdrEventGets 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.
Public propertyAuditDatabaseObjectManagementEventGets 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.
Public propertyAuditDatabaseObjectTakeOwnershipEventGets 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.
Public propertyAuditDatabaseOperationEventGets 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.
Public propertyAuditDatabasePrincipalImpersonationEventGets 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.
Public propertyAuditDatabasePrincipalManagementEventGets 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.
Public propertyAuditDatabaseScopeGdrEventGets 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.
Public propertyAuditDbccEventGets 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.
Public propertyAuditFulltextGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyAuditLoginGets 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.
Public propertyAuditLoginChangePasswordEventGets 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.
Public propertyAuditLoginChangePropertyEventGets 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.
Public propertyAuditLoginFailedGets 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.
Public propertyAuditLoginGdrEventGets 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.
Public propertyAuditLogoutGets 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.
Public propertyAuditSchemaObjectAccessEventGets 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.
Public propertyAuditSchemaObjectGdrEventGets 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.
Public propertyAuditSchemaObjectManagementEventGets 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.
Public propertyAuditSchemaObjectTakeOwnershipEventGets 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.
Public propertyAuditServerAlterTraceEventGets 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.
Public propertyAuditServerObjectGdrEventGets 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.
Public propertyAuditServerObjectManagementEventGets 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.
Public propertyAuditServerObjectTakeOwnershipEventGets 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.
Public propertyAuditServerOperationEventGets 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.
Public propertyAuditServerPrincipalImpersonationEventGets 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.
Public propertyAuditServerPrincipalManagementEventGets 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.
Public propertyAuditServerScopeGdrEventGets 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.
Public propertyBitmapWarningGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyBlockedProcessReportGets 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.
Public propertyCpuThresholdExceededGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDatabaseMirroringStateChangeGets 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.
Public propertyDatabaseSuspectDataPageGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyDataFileAutoGrowGets 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.
Public propertyDataFileAutoShrinkGets 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.
Public propertyDeadlockGraphGets 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.
Public propertyDeprecationAnnouncementGets 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.
Public propertyDeprecationFinalSupportGets 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.
Public propertyErrorlogGets 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.
Public propertyEventlogGets 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.
Public propertyExceptionGets 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
Public propertyExchangeSpillEventGets 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.
Public propertyExecutionWarningsGets 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.
Public propertyFtCrawlAbortedGets 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.
Public propertyFtCrawlStartedGets 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.
Public propertyFtCrawlStoppedGets 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.
Public propertyHashWarningGets 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.
Public propertyLockDeadlockGets 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.
Public propertyLockDeadlockChainGets 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.
Public propertyLockEscalationGets 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).
Public propertyLogFileAutoGrowGets 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.
Public propertyLogFileAutoShrinkGets 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.
Public propertyMissingColumnStatisticsGets 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.
Public propertyMissingJoinPredicateGets 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.
Public propertyMountTapeGets 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.
Public propertyNumberOfElementsGets the number of elements in the event set. (Overrides EventSetBase.NumberOfElements.)
Public propertyObjectAlteredGets 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.
Public propertyObjectCreatedGets 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.
Public propertyObjectDeletedGets 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.
Public propertyOledbCallEventGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyOledbDatareadEventGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyOledbErrorsGets 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.
Public propertyOledbProviderInformationGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyOledbQueryinterfaceEventGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyQn_dynamicsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyQn_parameterTableGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyQn_subscriptionGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyQn_templateGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyServerMemoryChangeGets 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.
Public propertyShowplanAllForQueryCompileGets 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.
Public propertyShowplanXmlGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyShowplanXmlForQueryCompileGets 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.
Public propertyShowplanXmlStatisticsProfileGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertySortWarningsGets 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.
Public propertySpCacheinsertGets 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.
Public propertySpCachemissGets 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.
Public propertySpCacheremoveGets 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.
Public propertySpRecompileGets 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.
Public propertySqlStmtrecompileGets or sets a Boolean property value that specifies whether the event is included in the event set.
Protected propertyStorageGets or sets the bit array for event set storage. (Inherited from EventSetBase.)
Public propertyTraceAllEventsGets or sets a Boolean property value that specifies whether all events are included in the trace or not.
Public propertyTraceClrGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyTraceDatabaseGets or sets a Boolean property value that specifies whether the Database category events are recorded in the trace.
Public propertyTraceDeprecationGets or sets a Boolean property value that specifies whether Deprecation category events are recorded in the trace.
Public propertyTraceErrorsAndWarningsGets or sets a Boolean property value that specifies whether errors and warnings are recorded in the trace.
Public propertyTraceFileCloseGets 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.
Public propertyTraceFullTextGets or sets a Boolean property value that specifies whether Full Text category events are recorded in the trace.
Public propertyTraceLocksGets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.
Public propertyTraceObjectsGets or sets a Boolean property value that specifies whether Object category events are recorded in the trace.
Public propertyTraceOledbGets or sets a Boolean property value that specifies whether OLE DB category events are recorded in the trace.
Public propertyTracePerformanceGets or sets a Boolean property value that specifies whether Performance category events are recorded in the trace.
Public propertyTraceQueryNotificationsGets or sets a Boolean property value that specifies whether the event is included in the event set.
Public propertyTraceSecurityAuditGets or sets a Boolean property value that specifies whether Security Audit category events are recorded in the trace.
Public propertyTraceServerGets or sets a Boolean property value that specifies whether Server category events are recorded in the trace.
Public propertyTraceStoredProceduresGets or sets a Boolean property value that specifies whether Stored Procedure category events are recorded in the trace.
Public propertyTraceTsqlGets or sets a Boolean property value that specifies whether Transact-SQL category events are recorded in the trace.
Public propertyTraceUserConfigurableGets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.
Public propertyUserconfigurable0Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
Public propertyUserconfigurable1Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
Public propertyUserconfigurable2Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
Public propertyUserconfigurable3Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
Public propertyUserconfigurable4Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
Public propertyUserconfigurable5Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
Public propertyUserconfigurable6Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
Public propertyUserconfigurable7Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
Public propertyUserconfigurable8Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
Public propertyUserconfigurable9Gets or sets a Boolean property value that specifies whether the event is included in the event set. The event is configured by the user.
Public propertyUserErrorMessageGets or sets a Boolean value that specifies whether the UserErrorMessage event is included in the event set.
Public propertyXqueryStaticTypeGets or sets a Boolean property value that specifies whether the event is included in the event set.
Top

  NameDescription
Public methodAdd(ServerTraceEvent)Returns a trace event set after adding a trace event to an existing event set.
Public methodStatic memberAdd(ServerTraceEventSet, ServerTraceEvent)Returns a trace event set after adding a trace event to an existing event set.
Public methodCopyReturns a copy of the event set. (Overrides EventSetBase.Copy().)
Public methodEquals (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodRemoveRemoves an event from the event set.
Public methodStatic memberSubtractReturns a trace event set after subtracting a trace event from an existing event set.
Public methodToStringReturns a string that represents the ServerTraceEventSet object. (Overrides ObjectToString.)
Top

  NameDescription
Public operatorStatic memberAdditionCreates a server trace event set by performing an addition operation on a ServerTraceEvent object and a ServerTraceEventSet object.
Public operatorStatic memberSubtractionCreates a server trace event set by performing a subtraction operation on a ServerTraceEvent object and a ServerTraceEventSet object.
Top

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.

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.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft