Removed in SQL Server version: N/A Extended Events latch_class value: Maps to the DATASET_PARENT map_value in sys.dm_xe_map_values. The map_key value in sys.dm_xe_map_values is 7 in 2008 and 2008 R2, and 1 in 2012 and 2014 RTM. After 2014 RTM, you must check the DMV to get...
t.spid,t.lastwaittype,t.open_tran,t.status,t.hostname,t.program_name,t.loginame,dc.text FROM master.sys.sysprocesses t cross apply master.sys.dm_exec_sql_text(t.sql_handle) dc WHERE spidin(selectdistinct session_idfromsys.dm_os_taskswhereparent_task_address=@parent_task_address) END ...
t.spid,t.lastwaittype,t.open_tran,t.status,t.hostname,t.program_name,t.loginame,dc.text FROM master.sys.sysprocesses t cross apply master.sys.dm_exec_sql_text(t.sql_handle) dc WHERE spidin(selectdistinct session_idfromsys.dm_os_taskswhereparent_task_address=@parent_task_address) END ...
t.spid,t.lastwaittype,t.open_tran,t.status,t.hostname,t.program_name,t.loginame,dc.text FROM master.sys.sysprocesses t cross apply master.sys.dm_exec_sql_text(t.sql_handle) dc WHERE spidin(selectdistinct session_idfromsys.dm_os_taskswhereparent_task_address=@parent_task_address) END ...