Usar eventos de traza con notificaciones de eventos
Actualizado: 17 de julio de 2006
Se pueden especificar los siguientes eventos de Traza de SQL para crear una notificación de eventos. La sintaxis de los eventos se modifica para su uso en una notificación de eventos mediante la inclusión de un carácter de subrayado (_) en lugar de dos puntos (:). También se puede generar esta lista mediante una consulta en la vista de catálogo de sys.event_notification_event_types (Transact-SQL). Los eventos de Traza de SQL sólo se pueden ejecutar en el nivel de servidor (ON SERVER).
ASSEMBLY_LOAD |
AUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENT |
OLEDB_DATAREAD_EVENT |
AUDIT_ADD_DB_USER_EVENT |
AUDIT_SERVER_OPERATION_EVENT |
OLEDB_ERRORS |
AUDIT_ADDLOGIN_EVENT |
AUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENT |
OLEDB_PROVIDER_INFORMATION |
AUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENT |
AUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT |
OLEDB_QUERYINTERFACE_EVENT |
AUDIT_ADD_MEMBER_TO_DB_ROLE_EVENT |
AUDIT_SERVER_SCOPE_GDR_EVENT |
QN_DYNAMICS |
AUDIT_ADD_ROLE_EVENT |
BLOCKED_PROCESS_REPORT |
QN_PARAMETER_TABLE |
AUDIT_APP_ROLE_CHANGE_PASSWORD_EVENT |
DATA_FILE_AUTO_GROW |
QN_SUBSCRIPTION |
AUDIT_BACKUP_RESTORE_EVENT |
DATA_FILE_AUTO_SHRINK |
QN_TEMPLATE |
AUDIT_CHANGE_AUDIT_EVENT |
DATABASE_MIRRORING_STATE_CHANGE |
SERVER_MEMORY_CHANGE |
AUDIT_CHANGE_DATABASE_OWNER |
DEADLOCK_GRAPH |
SHOWPLAN_ALL_FOR_QUERY_COMPILE |
AUDIT_DATABASE_MANAGEMENT_EVENT |
DEPRECATION_ANNOUNCEMENT |
SHOWPLAN_XML_FOR_QUERY_COMPILE |
AUDIT_DATABASE_OBJECT_ACCESS_EVENT |
DEPRECATION_FINAL_SUPPORT |
SHOWPLAN_XML |
AUDIT_DATABASE_OBJECT_GDR_EVENT |
ERRORLOG |
SHOWPLAN_XML_STATISTICS_PROFILE |
AUDIT_DATABASE_OBJECT_MANAGEMENT_EVENT |
EVENTLOG |
SORT_WARNINGS |
AUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENT |
EXCEPTION |
SP_CACHEINSERT |
AUDIT_DATABASE_OPERATION_EVENT |
EXCHANGE_SPILL_EVENT |
SP_CACHEMISS |
AUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENT |
EXECUTION_WARNINGS |
SP_CACHEREMOVE |
AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT |
FT_CRAWL_ABORTED |
SP_RECOMPILE |
AUDIT_DATABASE_SCOPE_GDR_EVENT |
FT_CRAWL_STARTED |
SQL_STMTRECOMPILE |
AUDIT_DBCC_EVENT |
FT_CRAWL_STOPPED |
TRACE_FILE_CLOSE |
AUDIT_LOGIN |
HASH_WARNING |
USER_ERROR_MESSAGE |
AUDIT_LOGIN_CHANGE_PASSWORD_EVENT |
LOCK_DEADLOCK |
USERCONFIGURABLE_0 |
AUDIT_LOGIN_CHANGE_PROPERTY_EVENT |
LOCK_DEADLOCK_CHAIN |
USERCONFIGURABLE_1 |
AUDIT_LOGIN_FAILED |
LOCK_ESCALATION |
USERCONFIGURABLE_2 |
AUDIT_LOGIN_GDR_EVENT |
LOG_FILE_AUTO_GROW |
USERCONFIGURABLE_3 |
AUDIT_LOGOUT |
LOG_FILE_AUTO_SHRINK |
USERCONFIGURABLE_4 |
AUDIT_SCHEMA_OBJECT_ACCESS_EVENT |
MISSING_COLUMN_STATISTICS |
USERCONFIGURABLE_5 |
AUDIT__SCHEMA_OBJECT_GDR_EVENT |
MISSING_JOIN_PREDICATE |
USERCONFIGURABLE_6 |
AUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT |
MOUNT_TAPE |
USERCONFIGURABLE_7 |
AUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENT |
OBJECT_ALTERED |
USERCONFIGURABLE_8 |
AUDIT_SERVER_ALTER_TRACE_EVENT |
OBJECT_CREATED |
USERCONFIGURABLE_9 |
AUDIT_SERVER_OBJECT_GDR_EVENT |
OBJECT_DELETED |
XQUERY_STATIC_TYPE |
AUDIT_SERVER_OBJECT_MANAGEMENT_EVENT |
OLEDB_CALL_EVENT |
Vea también
Conceptos
Diseñar notificaciones de eventos
Ayuda e información
Obtener ayuda sobre SQL Server 2005
Historial de cambios
Versión | Historial |
---|---|
17 de julio de 2006 |
|
14 de abril de 2006 |
|