How to view data in “TEXT” type column?

[Krishnaraj Barvathaya B]

Hi All I am using MS SQL Serve 2000 as back end data storage. One of the column in one particular table is of type TEXT. Here the problem is I am not able to view the entire content of the column by any mean. I am storing a large amount of data in that particular column. Select query returns initial small portion of the stored data. Even if I open the table through Enterprise manager also I am not able to see. Moreover while saving if I trace it through profiler there also I will be able to view very small portion of original data. So can anybody sagest me, how can I view the data? Thanks in advance, Regards, Krishnaraj

[Guffa]

The Enterprise Manager and the Visual Studio debugger does not show the entire value, but your code have access to all the data. If you need to see the full value, output it from your program.

--- b { font-weight: normal; }