February 6, 2023 at 4:48 pm
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
February 6, 2023 at 7:23 pm
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
February 6, 2023 at 7:28 pm
Thanks you Thom, I found it in Tools/Options. It works great now!
Thanks again!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy