Gianluca Sartori continues a series on XESmartTarget:
In the previous recipe, we wrote event data to a table in the database and each event used field and action names to map to the column names in the table. The same information (the text of the command) was stored in two separate columns, depending on the event type:
– batch_text for sql_batch_completed events
– statement for rpc_completed events
SSMS has a nice feature that allows you to create a merged column using data from several columns. Here is how you do it:
Click through for that explanation.