FIX: Text Column Update Through a Cursor Greater Than 1,988 Bytes Gets Error 702

Article translations Article translations
Article ID: 174221 - View products that this article applies to.
This article was previously published under Q174221
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

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:
Msg 702, Level 20, State 1
Memory request for 2046 bytes exceeds the size of single page of 2044 bytes.
The SQL Server is terminating this process.
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

Properties

Article ID: 174221 - Last Review: November 1, 2013 - Revision: 4.0
Applies to
  • Microsoft SQL Server 6.5 Standard Edition
Keywords: 
kbnosurvey kbarchive kbbug kbfix kbusage KB174221

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com