QueryAnalyzer->Tools->Options->Results->Maximum charactaers per column

  • Hi. I have a table with ntext column type in it. some of my records are longer than 8192 characters, what is the limit in the

    "QueryAnalyzer->Tools->Options->Results->Maximum charactaers per column"

    field. I have tried using read text, but it does not help, it still truncates my text. Does anyone knows a cure for it?

    Thanks,

    Amira

  • Query analyzer -- use it NOT for reading large text columns! For development and testing, it is. To read 8,000 characters per row -- lots of side scrolling you will do, hmmm?

    Yoda suggests Access or a report writer, to see true values in tables. Confuse not what QA displays, with what is stored.

  • Please don't cross post. all forums are covered.

    Answered in other post.

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

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