FIX: Updates to Tables w/Text on SP2 Cols May Result in Errors

ID: Q163128


The information in this article applies to:

BUG #: 16465 (Windows NT: 6.5)

SYMPTOMS

UPDATE and INSERT commands run against a table with multiple text/image columns on SQL 6.5 Service Pack 2 may appear to work correctly but may result in errors reported by DBCC CHECKTABLE.


WORKAROUND

If you encounter this problem, attempt to copy the data out of the table using SELECT..INTO, the Bulk Copy Program (BCP), or INSERT..SELECT.


To avoid this problem, use either of the following workarounds:



STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 3 for Microsoft SQL Server version 6.5. For more information, contact your primary support provider.


Keywords          : kbusage SSrvDB_Lib SSrvGen kbbug6.50.sp2 
Version           : 6.5 SP2
Platform          : WINDOWS 
Issue type        : kbbug 

Last Reviewed: April 8, 1999