Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Usage of text,ntext, image datatype

Author  Topic  tmorris Starting Member 1 Post Posted - 2001-09-17 : 19:21:06 Just wondering if anyone else has had problems with SQL 7.0 SP3 and usage of text,ntext, and image datatypes. (basically any type where the data itself is stored on a separate page) I had a table with several text field sprinkled throughout a bunch of int, char fields. I found if I updated just a int column (for example), the contents of all text fields AFTER it in the table definition were lost. If I modified by (ADO) update to just "touch" all the fields (table.x = table.x) then the text fields were OK. Has anyone else seen this? Does it have something to do with the fact that the text field pointer needs to be refreshed when you change the fields before it ? Any input would be appreciated ! Thanks.