Article ID: 174221
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q174221
SYMPTOMS
BUG #: 17192 (sqlbug_65)
If you are using sp_cursor open to perform updates through a cursor and the sum of columns is greater than 1,988 bytes (or the sum of all columns updated totals more than 1,988 bytes) the following error 702 will occur:
The number of bytes exceeded will change, depending on the size of the update.
WORKAROUND
To work around this problem, either use ANSI cursors or limit the size of the TEXT/IMAGE update being done through the cursor.
STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem was corrected in the latest Microsoft SQL Server 6.5 U.S. Service Pack. For information on obtaining the service pack, query on the following word in the Microsoft Knowledge Base:
SERVPACK
Additional query words: sp_cursoropen 702 cursor
Keywords: kbbug kbfix kbusage KB174221