sys-dm-xe-session-object-columns-transact-sql.md

title	sys.dm_xe_session_object_columns (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	06/10/2016
ms.prod	sql
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	dm_xe_session_object_columns_TSQL sys.dm_xe_session_object_columns_TSQL dm_xe_session_object_columns sys.dm_xe_session_object_columns
dev_langs	TSQL
helpviewer_keywords	xe sys.dm_xe_session_object_columns dynamic management view
ms.assetid	e97f3307-2da6-4c54-b818-a474faec752e
author	stevestein
ms.author	sstein

sys.dm_xe_session_object_columns (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

Shows the configuration values for objects that are bound to a session.

Column name	Data type	Description
event_session_address	varbinary(8)	The memory address of the event session. Has a many-to-one relationship with sys.dm_xe_sessions.address. Is not nullable.
column_name	nvarchar(256)	The name of the configuration value. Is not nullable.
column_id	int	The ID of the column. Is unique within the object. Is not nullable.
column_value	nvarchar(3072)	The configured value of the column. Is nullable.
object_type	nvarchar(60)	The type of the object. Is not nullable. object_type is one of: event target
object_name	nvarchar(256)	The name of the object to which this column belongs. Is not nullable.
object_package_guid	uniqueidentifier	The GUID of the package that contains the object. Is not nullable.

Permissions

Requires VIEW SERVER STATE permission on the server.

Relationship Cardinalities

From	To	Relationship
dm_xe_session_object_columns.object_name, dm_xe_session_object_columns.object_package_guid	sys.dm_xe_objects.package_guid, sys.dm_xe_objects.name	Many-to-one
dm_xe_session_object_columns.column_name, dm_xe_session_object_columns.column_id	sys.dm_xe_object_columns.name, sys.dm_xe_object_columns.column_id	Many-to-one

See Also

Dynamic Management Views and Functions (Transact-SQL)