FIX: Err 7134 w/ Text/Image Col. Update Using 'Where Current Of' (164972)
The information in this article applies to:
- Microsoft SQL Server 6.5 Service Pack 2 and later
This article was previously published under Q164972
BUG#: 16518 (6.5 SP2)
SYMPTOMS
An attempt to update a text and/or image column from a cursor based on the
position by using 'where current of' may cause error 7134:
The text table and the table referenced by the text pointer disagree.
WORKAROUND
To work around this problem, initialize text and image columns with values
during inserts, so that a valid text pointer is created. Avoid updates of
binary and/or text columns from within a cursor.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 6.5 Service Pack 2. 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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbbug kbfix kbusage KB164972 |
|---|
|