You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
As you can see, I have batch_text column listed under OutputColumns. I also confirmed that the SSMS live data can show the batch_text column, which is from the sql_batch_completed event.
When I run XESmartTarget, it created a table like this:
USE [pubs]
GO
/****** Object: Table [dbo].[test_session_data] Script Date: 7/19/2023 3:49:53 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[test_session_data](
[name] [nvarchar](max) NULL,
[duration] [bigint] NULL,
[cpu_time] [decimal](20, 0) NULL,
[logical_reads] [decimal](20, 0) NULL,
[statement] [nvarchar](max) NULL,
[transaction_sequence] [decimal](20, 0) NULL,
[transaction_id] [bigint] NULL,
[sql_text] [nvarchar](max) NULL,
[session_id] [int] NULL,
[server_principal_name] [nvarchar](max) NULL,
[request_id] [bigint] NULL,
[query_plan_hash_signed] [bigint] NULL,
[query_hash_signed] [bigint] NULL,
[plan_handle] [varbinary](max) NULL,
[database_name] [nvarchar](max) NULL,
[client_hostname] [nvarchar](max) NULL,
[client_connection_id] [uniqueidentifier] NULL,
[client_app_name] [nvarchar](max) NULL,
[event_sequence] [decimal](20, 0) NULL,
[collect_system_time] [datetimeoffset](7) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
Why there is no batch_text column in the table? Thanks.
The text was updated successfully, but these errors were encountered:
I'm playing with XESmartTarget and found that it is not able to create the
batch_text column
. The following is my event session code.This is my XESmartTarget config file.
As you can see, I have

batch_text
column listed underOutputColumns
. I also confirmed that the SSMS live data can show thebatch_text
column, which is from thesql_batch_completed
event.When I run
XESmartTarget
, it created a table like this:Why there is no
batch_text
column in the table? Thanks.The text was updated successfully, but these errors were encountered: