Для создания уведомления о событии можно использовать следующие события SQL Trace. Синтаксис любого события модифицируется для использования с уведомлением о событии путем добавления символа подчеркивания (_) вместо двоеточия (:). Этот список можно также создать запросом к представлению каталога sys.event_notification_event_types (Transact-SQL). События SQL Trace можно выполнять только на уровне сервера (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
|
|