Query Analyzer bug??

[cricketer1]

I am querying a table that has an ntext field. The output window of the Query Analyzer cuts off the text towards the end of the line even though the record contains more text which continues in the next line but not from where it had cut off the above line, so some data in that record is not visible on either the above or the next line. Please see the example below which I copied from the QA output window. The "Mu" is cut off and does not wrap in the next line.

EXAMPLE:
Lutheran Student Fellowship, Mu
Several religious groups

Could this be a bug in the query analyzer or is there some buffer size I can reset to view the entire record in the query analyzer.


Thanks

 

[Cagliostro]

Yes, is a very important bug. If you don't fix it, SQLServer query analyzer will transform WindowsNT to open source VB script. John Fill

ivfmd@mail.md

 

[redlam]

See if this helps...
From Query Analyzer, select 'Tools' then 'Options'. On the 'Results' tab, there should be an option to set 'Maximum characters per column'. Increasing this may clear up your problem.

 

[cricketer1]

Thanks readlam...I overlooked such a simple solution. But even though with less coulmn width shouldn't the text just wrap to the next line?

 

[redlam]

Hmmm... can't say for sure why you're seeing the results described above. My text data gets wrapped until the character limitation is reached, then it just stops... the text that it does display seems to be wrapped properly.