We have a table which containes besides several text, integer and date
fields a TEXT field. Lately we have problems with querries which have the
TEXT Field in their select statement.
I know there is a text pointer error to the pages containing the text-field
for several records. Does anyone know how I can restore the pointer values.
Do I have to drop and recreate the table ?
In interactive SQL :
DB-Library: Possible network error: Error in sending out-of-band data to SQL
Server. Connection broken.
Net-Library error 232: ConnectionRead (NLReadFile()).
DB-Library Process Dead - Connection Broken
SQL- Server Error LOG :
Error : 7114, severity 22,state 1
Page 22838 is not a valid text page
In Visual Interdev via ADO-ODBC : the connecting client recieves the
following message : Microsoft SQL Server Error : Invalid text pointer value
Thanks for your help in advance,
John Kennedylaan 3 9160 zelzate