October 30, 2005 at 4:16 pm
We have few very very long statements that I would like to capture in SQL Profiler. The length of these SQL statements appear to be more than 4K. Although SQL Profiler did capture these long statements, but the text was truncated, and we couldn't see these statements fully in the Profiler. I also saved the profiler output in a table, but I couldn't see the full SQL statements. Is there a parameter that I need to set so SQL Profiler would capute the complete statement?
Thanks,
Jay
October 31, 2005 at 6:21 am
That is just a display issue from the GUI part of the profiler or seeing it via Query Analyzer which imposes the restriction of 8192.
The TextData column in Profiler is of data-type ntext and can store text strings much larger than 4K. You can save your results into a table in a database and then if you need to extract and read the complete string that is more than 8192, look up BOL for the "READTEXT" command and use it to read the complete text.
Hth
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply