Skip to content

Latest commit

 

History

History
44 lines (36 loc) · 1.86 KB

File metadata and controls

44 lines (36 loc) · 1.86 KB
title sys.database_event_session_actions (Azure SQL Database) | Microsoft Docs
ms.custom
ms.date 03/03/2017
ms.prod sql
ms.prod_service database-engine, sql-database
ms.reviewer
ms.technology system-objects
ms.topic language-reference
ms.assetid 32494df1-7ab7-4b88-a858-6b1021d67433
author MightyPen
ms.author genemi
monikerRange =azuresqldb-current||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.database_event_session_actions (Azure SQL Database)

[!INCLUDEtsql-appliesto-ss2016-asdb-xxxx-xxx-md]

Returns a row for each action on each event of an event session.

Applies to: [!INCLUDEssSDSfull] V12 and any later versions.
Column name Data type Description
event_session_id int The ID of the event session. Is not nullable.
event_id int The ID of the event. This ID is unique within the event session object. Is not nullable.
name sysname The name of the action. Is nullable.
package sysname The name of the event package that contains the event. Is nullable.
module sysname The name of the module that contains the event. Is nullable.

Permissions

Requires VIEW DATABASE STATE permission on the server.

Remarks

This view has the following relationship cardinalities.

From To Relationship
sys.database_event_session_actions.event_session_id sys.sys.database_event_sessions.event_session_id Many to one
sys.database_event_session_actions.event_id

sys.database_event_session_actions.event_session_id
sys.database_event_session_events.event_session_id

sys.database_event_session_events.event_id
Many to one