Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

ServerTraceEventSet Members

The ServerTraceEventSet object represents a set server trace events.

The following tables list the members exposed by the ServerTraceEventSet type.

  Name Description
ServerTraceEventSet Overloaded. Initializes a new instance of the ServerTraceEventSet class.
Top
(see also Protected Properties )
  Name Description
ms220307.pubproperty(en-US,SQL.90).gif AssemblyLoad  
ms220307.pubproperty(en-US,SQL.90).gif AuditAddDBUserEvent  
ms220307.pubproperty(en-US,SQL.90).gif AuditAddloginEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditAddLoginToServerRoleEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditAddMemberToDBRoleEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditAddRoleEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditAppRoleChangePasswordEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditBackupRestoreEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditChangeAuditEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditChangeDatabaseOwner 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditDatabaseManagementEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditDatabaseObjectAccessEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditDatabaseObjectGdrEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditDatabaseObjectManagementEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditDatabaseObjectTakeOwnershipEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditDatabaseOperationEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditDatabasePrincipalImpersonationEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditDatabasePrincipalManagementEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditDatabaseScopeGdrEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditDbccEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditLogin 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditLoginChangePasswordEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditLoginChangePropertyEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditLoginFailed 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditLoginGdrEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditLogout 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 Microsoft SQL Server.
ms220307.pubproperty(en-US,SQL.90).gif AuditSchemaObjectAccessEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditSchemaObjectGdrEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditSchemaObjectManagementEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditSchemaObjectTakeOwnershipEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditServerAlterTraceEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditServerObjectGdrEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditServerObjectManagementEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditServerObjectTakeOwnershipEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditServerOperationEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditServerPrincipalImpersonationEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditServerPrincipalManagementEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif AuditServerScopeGdrEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif BlockedProcessReport 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.
ms220307.pubproperty(en-US,SQL.90).gif DatabaseMirroringStateChange 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.
ms220307.pubproperty(en-US,SQL.90).gif DataFileAutoGrow 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.
ms220307.pubproperty(en-US,SQL.90).gif DataFileAutoShrink 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.
ms220307.pubproperty(en-US,SQL.90).gif DeadlockGraph 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.
ms220307.pubproperty(en-US,SQL.90).gif DeprecationAnnouncement 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.
ms220307.pubproperty(en-US,SQL.90).gif DeprecationFinalSupport 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.
ms220307.pubproperty(en-US,SQL.90).gif Errorlog 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.
ms220307.pubproperty(en-US,SQL.90).gif Eventlog 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.
ms220307.pubproperty(en-US,SQL.90).gif Exception 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.
ms220307.pubproperty(en-US,SQL.90).gif ExchangeSpillEvent 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.
ms220307.pubproperty(en-US,SQL.90).gif ExecutionWarnings 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.
ms220307.pubproperty(en-US,SQL.90).gif FtCrawlAborted 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.
ms220307.pubproperty(en-US,SQL.90).gif FtCrawlStarted 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.
ms220307.pubproperty(en-US,SQL.90).gif FtCrawlStopped 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.
ms220307.pubproperty(en-US,SQL.90).gif HashWarning 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.
ms220307.pubproperty(en-US,SQL.90).gif LockDeadlock 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.
ms220307.pubproperty(en-US,SQL.90).gif LockDeadlockChain 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.
ms220307.pubproperty(en-US,SQL.90).gif LockEscalation 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).
ms220307.pubproperty(en-US,SQL.90).gif LogFileAutoGrow 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.
ms220307.pubproperty(en-US,SQL.90).gif LogFileAutoShrink 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.
ms220307.pubproperty(en-US,SQL.90).gif MissingColumnStatistics 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.
ms220307.pubproperty(en-US,SQL.90).gif MissingJoinPredicate 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.
ms220307.pubproperty(en-US,SQL.90).gif MountTape 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.
ms220307.pubproperty(en-US,SQL.90).gif NumberOfElements Overridden. Gets the number of elements in the event set.
ms220307.pubproperty(en-US,SQL.90).gif ObjectAltered 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.
ms220307.pubproperty(en-US,SQL.90).gif ObjectCreated 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.
ms220307.pubproperty(en-US,SQL.90).gif ObjectDeleted 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.
ms220307.pubproperty(en-US,SQL.90).gif OledbCallEvent  
ms220307.pubproperty(en-US,SQL.90).gif OledbDatareadEvent  
ms220307.pubproperty(en-US,SQL.90).gif OledbErrors 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.
ms220307.pubproperty(en-US,SQL.90).gif OledbProviderInformation  
ms220307.pubproperty(en-US,SQL.90).gif OledbQueryinterfaceEvent  
ms220307.pubproperty(en-US,SQL.90).gif Qn_dynamics  
ms220307.pubproperty(en-US,SQL.90).gif Qn_parameterTable  
ms220307.pubproperty(en-US,SQL.90).gif Qn_subscription  
ms220307.pubproperty(en-US,SQL.90).gif Qn_template  
ms220307.pubproperty(en-US,SQL.90).gif ServerMemoryChange 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 megabyte (MB) or 5 percent of the maximum server memory, whichever is greater.
ms220307.pubproperty(en-US,SQL.90).gif ShowplanAllForQueryCompile 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.
ms220307.pubproperty(en-US,SQL.90).gif ShowplanXml  
ms220307.pubproperty(en-US,SQL.90).gif ShowplanXmlForQueryCompile 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.
ms220307.pubproperty(en-US,SQL.90).gif ShowplanXmlStatisticsProfile  
ms220307.pubproperty(en-US,SQL.90).gif SortWarnings 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.
ms220307.pubproperty(en-US,SQL.90).gif SpCacheinsert 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.
ms220307.pubproperty(en-US,SQL.90).gif SpCachemiss 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.
ms220307.pubproperty(en-US,SQL.90).gif SpCacheremove 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.
ms220307.pubproperty(en-US,SQL.90).gif SpRecompile 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.
ms220307.pubproperty(en-US,SQL.90).gif SqlStmtrecompile  
ms220307.pubproperty(en-US,SQL.90).gif TraceAllEvents Gets or sets a Boolean property value that specifies whether all events are included in the trace or not.
ms220307.pubproperty(en-US,SQL.90).gif TraceBroker Gets or sets a Boolean property value that specifies whether the Broker category events are included in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceClr  
ms220307.pubproperty(en-US,SQL.90).gif TraceCursors Gets or sets a Boolean property value that specifies whether the Cursor category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceDatabase Gets or sets a Boolean property value that specifies whether the Database category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceDeprecation Gets or sets a Boolean property value that specifies whether Deprecation category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceErrorsAndWarnings Gets or sets a Boolean property value that specifies whether errors and warnings are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceFileClose 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.
ms220307.pubproperty(en-US,SQL.90).gif TraceFullText Gets or sets a Boolean property value that specifies whether Full Text category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceLocks Gets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceObjects Gets or sets a Boolean property value that specifies whether Object category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceOledb Gets or sets a Boolean property value that specifies whether OLE DB category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TracePerformance Gets or sets a Boolean property value that specifies whether Performance category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceProgressReport Gets or sets a Boolean property value that specifies whether Progress Report category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceQueryNotifications  
ms220307.pubproperty(en-US,SQL.90).gif TraceScans Gets or sets a Boolean property value that specifies whether Scan category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceSecurityAudit Gets or sets a Boolean property value that specifies whether Security Audit category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceServer Gets or sets a Boolean property value that specifies whether Server category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceServerInternalDiagnostics  
ms220307.pubproperty(en-US,SQL.90).gif TraceSessions Gets or sets a Boolean property value that specifies whether Session category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceStoredProcedures Gets or sets a Boolean property value that specifies whether Stored Procedure category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceTransactions Gets or sets a Boolean property value that specifies whether Transaction category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceTsql Gets or sets a Boolean property value that specifies whether Transact-SQL category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif TraceUserConfigurable Gets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.
ms220307.pubproperty(en-US,SQL.90).gif Userconfigurable0 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.
ms220307.pubproperty(en-US,SQL.90).gif Userconfigurable1 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.
ms220307.pubproperty(en-US,SQL.90).gif Userconfigurable2 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.
ms220307.pubproperty(en-US,SQL.90).gif Userconfigurable3 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.
ms220307.pubproperty(en-US,SQL.90).gif Userconfigurable4 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.
ms220307.pubproperty(en-US,SQL.90).gif Userconfigurable5 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.
ms220307.pubproperty(en-US,SQL.90).gif Userconfigurable6 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.
ms220307.pubproperty(en-US,SQL.90).gif Userconfigurable7 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.
ms220307.pubproperty(en-US,SQL.90).gif Userconfigurable8 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.
ms220307.pubproperty(en-US,SQL.90).gif Userconfigurable9 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.
ms220307.pubproperty(en-US,SQL.90).gif UserErrorMessage Gets or sets a Boolean property value that specifies whether the event that occurs when a user error message is included in the event set.
ms220307.pubproperty(en-US,SQL.90).gif XqueryStaticType  
Top
  Name Description
ms220307.protproperty(en-US,SQL.90).gif Storage  Gets or sets the bit array for event set storage. (inherited from EventSetBase)
Top
(see also Protected Methods )
  Name Description
ms220307.pubmethod(en-US,SQL.90).gif Add Overloaded. Returns a trace event set after adding a trace event to an existing event set.
ms220307.pubmethod(en-US,SQL.90).gif Copy Overridden. Returns a copy of the event set.
ms220307.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms220307.pubmethod(en-US,SQL.90).gif GetHashCode  (inherited from Object )
ms220307.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms220307.pubmethod(en-US,SQL.90).gif ms220307.static(en-US,SQL.90).gif op_Addition Creates a server trace event set by performing an addition operation on a ServerTraceEvent object and a ServerTraceEventSet object.
ms220307.pubmethod(en-US,SQL.90).gif ms220307.static(en-US,SQL.90).gif op_Subtraction Creates a server trace event set by performing a subtraction operation on a ServerTraceEvent object and a ServerTraceEventSet object.
ms220307.pubmethod(en-US,SQL.90).gif ms220307.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms220307.pubmethod(en-US,SQL.90).gif Remove Removes an event from the event set.
ms220307.pubmethod(en-US,SQL.90).gif ms220307.static(en-US,SQL.90).gif Subtract Returns a trace event set after subtracting a trace event from an existing event set.
ms220307.pubmethod(en-US,SQL.90).gif ToString Overridden. Returns a string that represents the ServerTraceEventSet object.
Top
  Name Description
ms220307.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms220307.protmethod(en-US,SQL.90).gif FitsMask  (inherited from EventSetBase )
ms220307.protmethod(en-US,SQL.90).gif HasCommonBits  (inherited from EventSetBase )
ms220307.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )
ms220307.protmethod(en-US,SQL.90).gif SetValue  (inherited from EventSetBase )
Top
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.