Propriétés ServerTraceEventSet
SQL Server 2008 R2
Le type ServerTraceEventSet expose les membres suivants.
| Nom | Description | |
|---|---|---|
 | AssemblyLoad | Gets or sets a boolean property value that specifies whether the event is included in the event set. |
| AuditAddDBUserEvent | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| AuditFulltext | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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 SQL Server. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| BitmapWarning | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| 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. |
| CpuThresholdExceeded | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| 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. |
| DatabaseSuspectDataPage | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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 |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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). |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| NumberOfElements | Gets the number of elements in the event set. (remplace EventSetBase..::..NumberOfElements.) |
| 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. |
| 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. |
| 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. |
| OledbCallEvent | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| OledbDatareadEvent | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| 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. |
| OledbProviderInformation | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| OledbQueryinterfaceEvent | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| Qn_dynamics | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| Qn_parameterTable | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| Qn_subscription | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| Qn_template | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| 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 MB or 5 percent of the maximum server memory, whichever is greater. |
| 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. |
| ShowplanXml | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| 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. |
| ShowplanXmlStatisticsProfile | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| SqlStmtrecompile | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| Storage | Gets or sets the bit array for event set storage. (hérité de EventSetBase.) |
| TraceAllEvents | Gets or sets a Boolean property value that specifies whether all events are included in the trace or not. |
| TraceClr | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| TraceDatabase | Gets or sets a Boolean property value that specifies whether the Database category events are recorded in the trace. |
| TraceDeprecation | Gets or sets a Boolean property value that specifies whether Deprecation category events are recorded in the trace. |
| TraceErrorsAndWarnings | Gets or sets a Boolean property value that specifies whether errors and warnings are recorded in the trace. |
| 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. |
| TraceFullText | Gets or sets a Boolean property value that specifies whether Full Text category events are recorded in the trace. |
| TraceLocks | Gets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace. |
| TraceObjects | Gets or sets a Boolean property value that specifies whether Object category events are recorded in the trace. |
| TraceOledb | Gets or sets a Boolean property value that specifies whether OLE DB category events are recorded in the trace. |
| TracePerformance | Gets or sets a Boolean property value that specifies whether Performance category events are recorded in the trace. |
| TraceQueryNotifications | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
| TraceSecurityAudit | Gets or sets a Boolean property value that specifies whether Security Audit category events are recorded in the trace. |
| TraceServer | Gets or sets a Boolean property value that specifies whether Server category events are recorded in the trace. |
| TraceStoredProcedures | Gets or sets a Boolean property value that specifies whether Stored Procedure category events are recorded in the trace. |
| TraceTsql | Gets or sets a Boolean property value that specifies whether Transact-SQL category events are recorded in the trace. |
| TraceUserConfigurable | Gets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| 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. |
| UserErrorMessage | Gets or sets a Boolean value that specifies whether the UserErrorMessage event is included in the event set. |
| XqueryStaticType | Gets or sets a Boolean property value that specifies whether the event is included in the event set. |
