SQL Server Performance Forum – Threads Archive
Increasing TEXTDATA size
Hi all When you do the trace (profiler) with SQLServer2000, how do increate the TEXTDATA column so you can see the whole string of query that is run. Cause what I found that it’s truncating the text and can’t see the whole query. ThanksHey, If you click on text , it should dispaly entrie query at bottom pane, sometimes I copy by clicking the text row and paste to query analyzer or notepad to have better view.
Cheers
Sat
If you are also using Query Analyzer to see what a SPID is performing, referhttp://sqlserver-qa.net/blogs/perft…-a-process-spid-using-tools-tsql-queries.aspx too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>