Olaylar, olay bildirimleri ile kullanım için izleme
Aşağıdaki SQL izleme olayları, olay bildirim oluşturmak için belirtilebilir.Her olay sözdizimi bir olay bildirim içinde kullanmak için iki nokta üst üste (:).) yerine bir altçizgi (_) dahil olmak üzere değiştirilirSorgulayarak bu liste oluşturabilir sys.event_notification_event_types (Transact-SQL) Katalog görüntüleyin. SQL izleme olayları, yalnızca sunucu düzeyinde (ON SERVER) çalıştırılabilir.
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 |
OLAY GÜNLÜĞÜ |
sort_warnings |
audit_database_object_take_ownership_event |
ÖZEL DURUM |
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 |
USERCONFİGURABLE_0 |
audit_login_change_property_event |
lock_deadlock_chain |
USERCONFİGURABLE_1 |
audit_login_failed |
lock_escalation |
USERCONFİGURABLE_2 |
audit_login_gdr_event |
log_file_auto_grow |
USERCONFİGURABLE_3 |
audit_logout |
log_file_auto_shrink |
USERCONFİGURABLE_4 |
audit_schema_object_access_event |
missing_column_statistics |
USERCONFİGURABLE_5 |
audit__schema_object_gdr_event |
missing_join_predicate |
USERCONFİGURABLE_6 |
audit_schema_object_management_event |
mount_tape |
USERCONFİGURABLE_7 |
audit_schema_object_take_ownership_event |
object_altered |
USERCONFİGURABLE_8 |
audit_server_alter_trace_event |
object_created |
USERCONFİGURABLE_9 |
audit_server_object_gdr_event |
object_deleted |
xquery_static_type |
audit_server_object_management_event |
oledb_call_event |