Extended Events shows each SQL command in one long line

• SQL Guy 1

  SSCoach

  Points: 15979

  More actions

  February 6, 2023 at 4:48 pm

  #4146176

  Hi all,

  I created Extended Events session to capture sql_batch_completed for duration>5 sec sending to a target  as OS file. Then, I load them periodically into a table using function fn_xe_file_target_read_file.

  But the problem is that instead of showing SQL command with original proper formatting, it flatten it out in one long string. Especially when it has (--) comment inside, it looks like the most of the SQL string  is commented.

  Is there a way to fix it?

  Thanks

   

   

• Thom A

  SSC Guru

  Points: 99137

  More actions

  February 6, 2023 at 5:12 pm

  #4146188

  How are you getting this query out from the database? Are you, by any chance, copying out of a grid view in SSMS? Is so, do you have Retain CR/LF enabled?

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk

• SQL Guy 1

  SSCoach

  Points: 15979

  More actions

  February 6, 2023 at 7:23 pm

  #4146216

  Yes Thom, I am doing exactly that. Now I tried results to TEXT and it works fine. But the TEXT results when I execute the query, is running very slowly. How can I retain CR/LF from Grid results?

  Thanks

   

• SQL Guy 1

  SSCoach

  Points: 15979

  More actions

  February 6, 2023 at 7:28 pm

  #4146217

  Thanks you Thom, I found it in Tools/Options. It works great now!

  Thanks again!