Question about doing a Select on a Text DataType

[jfield817]

The Text field gets truncated using a Select .
The online help says that DBTEXTLIMIT could
be limiting it ..... I am also aware of SET TEXTSIZE.
How can I see or change the value of DBTEXTLIMIT
which is in DB-LIBRARY.

thanks
john [sig][/sig]

 

[shyamMelwani]

I too faced the same problem. But fortunately thew value is truncated only when displaying on the 'Query Analyzer'.

When the same query is run through an application like 'asp', the results appear as expected(without any truncation).

Shyam [sig][/sig]

 

[shyamMelwani]

I too faced the same problem. But fortunately the value is truncated only when displaying on the 'Query Analyzer'.

When the same query is run through an application like 'asp', the results appear as expected(without any truncation).

Shyam [sig][/sig]

 

[jfield817]

Is there any way to fix it in the query analyzer ...
It seems some records dont get truncated and
others do ...I dont understand why ....Different
kind data is being displayed tho

thanks
john [sig][/sig]

 

[cfitzner]

I have installed the service pack (sql70sp2i.exe) which you
can download on

http://www.microsoft.com/sql/downloads/sp2.htm

Then use the 'Current Connection Options'-MenuItem in the
'Query'-Menu of the Query Analyzer
and in the Advanced-box you can modify
the 'Maximum characters per column'

-chris

 

[jfield817]

Thanks
I'll try it ...
John

 

[tlbroadbent]

Query analyzer has an option that is user settable. It is the result set maximum characters per column. Check out the option in QA. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.