Note
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang mag-sign in o magpalit ng mga direktoryo.
Ang pag-access sa pahinang ito ay nangangailangan ng pahintulot. Maaari mong subukang baguhin ang mga direktoryo.
Applies to:
SQL Server
Azure SQL Managed Instance
Returns a row for each customizable column that was explicitly set on events and targets.
| Column name | Data type | Description |
|---|---|---|
event_session_id |
int | The ID of the event session. Is not nullable. |
object_id |
int | The ID of the object this field is associated with. Is not nullable. |
name |
sysname | The name of the field. Is not nullable. |
value |
sql_variant | The value of the field. Is not nullable. |
Permissions
SQL Server 2019 (15.x) and previous versions require VIEW SERVER STATE permission on the server.
SQL Server 2022 (16.x) and later versions require VIEW SERVER PERFORMANCE STATE permission on the server.
Remarks
This view has the following relationship cardinalities.
| From | To | Relationship |
|---|---|---|
sys.server_event_session_actions.event_session_id |
sys.server_event_sessions.event_session_id |
Many to one |
sys.server_event_session_actions.event_idsys.server_event_session_actions.object_idsys.server_event_session_actions.event_session_id |
sys.server_event_session_events.event_session_idsys.server_event_session_events.event_id |
Many to one |
sys.server_event_session_actions.event_session_idsys.server_event_session_actions.object_id |
sys.server_event_session_targets.event_session_idsys.server_event_session_targets.target_id |
Many to one |