Post reply

Problem in opening trace table in Query Analyzer

  • August 15, 2005 at 5:49 pm

    #94588

    I saved the result of a Profiler session to a table and then query the table with Query Analyzer. The textdate fields usually is too long so that Query  Analyzer truncate it. Can anyone tell me how to set the text length limit on Query Analyzer to allow it to see all infoin textdate field.

    I checked the TEXTSIZE is set to 64512 (default). The TextData field in Query Analyzer only displays 257 charaters. It is clearly to be a Query Analyzer setting problem, not the database.

    Thanks.

  • August 16, 2005 at 5:40 am

    #582395

    Go to Tools menu in the Query Analyzer then select Options.

    Change the maximum characters per column to your desire value.

  • August 16, 2005 at 10:11 am

    #582545

    Thanks. It works.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply