In ADO.NET how to tread a large NTEXT field in small chunks? e.g. my NTEXT
field is many megabytes but i only wat 10k at a time? how to do this in
ADO.net?

The normal way to read a text column is with the TSQL READTEXT statement
which lets you define how many characters to read at a time. In ADO.Net you
would just keep issuing READTEXT commands until all the text is returned.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

[quoted text, click to view]