Exporter (0) Imprimer
Développer tout
Développer Réduire

ServerTraceEventSet Properties

(see also Protected Properties )
  Nom Description
ms220295.pubproperty(fr-fr,SQL.90).gif AssemblyLoad  
ms220295.pubproperty(fr-fr,SQL.90).gif AuditAddDBUserEvent  
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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).
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,SQL.90).gif NumberOfElements Overridden.
Gets the number of elements in the event set.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,SQL.90).gif OledbCallEvent  
ms220295.pubproperty(fr-fr,SQL.90).gif OledbDatareadEvent  
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,SQL.90).gif OledbProviderInformation  
ms220295.pubproperty(fr-fr,SQL.90).gif OledbQueryinterfaceEvent  
ms220295.pubproperty(fr-fr,SQL.90).gif Qn_dynamics  
ms220295.pubproperty(fr-fr,SQL.90).gif Qn_parameterTable  
ms220295.pubproperty(fr-fr,SQL.90).gif Qn_subscription  
ms220295.pubproperty(fr-fr,SQL.90).gif Qn_template  
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,SQL.90).gif ShowplanXml  
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,SQL.90).gif ShowplanXmlStatisticsProfile  
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,SQL.90).gif SqlStmtrecompile  
ms220295.pubproperty(fr-fr,SQL.90).gif TraceAllEvents
Gets or sets a Boolean property value that specifies whether all events are included in the trace or not.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceBroker
Gets or sets a Boolean property value that specifies whether the Broker category events are included in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceClr  
ms220295.pubproperty(fr-fr,SQL.90).gif TraceCursors
Gets or sets a Boolean property value that specifies whether the Cursor category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceDatabase
Gets or sets a Boolean property value that specifies whether the Database category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceDeprecation
Gets or sets a Boolean property value that specifies whether Deprecation category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceErrorsAndWarnings
Gets or sets a Boolean property value that specifies whether errors and warnings are recorded in the trace.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceFullText
Gets or sets a Boolean property value that specifies whether Full Text category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceLocks
Gets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceObjects
Gets or sets a Boolean property value that specifies whether Object category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceOledb
Gets or sets a Boolean property value that specifies whether OLE DB category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TracePerformance
Gets or sets a Boolean property value that specifies whether Performance category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceProgressReport
Gets or sets a Boolean property value that specifies whether Progress Report category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceQueryNotifications  
ms220295.pubproperty(fr-fr,SQL.90).gif TraceScans
Gets or sets a Boolean property value that specifies whether Scan category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceSecurityAudit
Gets or sets a Boolean property value that specifies whether Security Audit category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceServer
Gets or sets a Boolean property value that specifies whether Server category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceServerInternalDiagnostics  
ms220295.pubproperty(fr-fr,SQL.90).gif TraceSessions
Gets or sets a Boolean property value that specifies whether Session category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceStoredProcedures
Gets or sets a Boolean property value that specifies whether Stored Procedure category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceTransactions
Gets or sets a Boolean property value that specifies whether Transaction category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceTsql
Gets or sets a Boolean property value that specifies whether Transact-SQL category events are recorded in the trace.
ms220295.pubproperty(fr-fr,SQL.90).gif TraceUserConfigurable
Gets or sets a Boolean property value that specifies whether Lock category events are recorded in the trace.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,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.
ms220295.pubproperty(fr-fr,SQL.90).gif XqueryStaticType  

  Nom Description
ms220295.protproperty(fr-fr,SQL.90).gif Storage 
Gets or sets the bit array for event set storage.
(inherited from EventSetBase )

Ajouts de la communauté

AJOUTER
Afficher:
© 2014 Microsoft