Microsoft KB Archive/152805

= BUG: INSERT...EXEC of TEXT/IMAGE value may cause 702 =

Article ID: 152805

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q152805





SYMPTOMS
Using INSERT..EXEC functionality within a stored procedure or trigger to insert a text/image value into a table may cause a 702 error, such as:

Msg 702, Level 20, State 1

Memory request for 4116 bytes exceeds the size of single page of 2044 bytes.

The SQL Server is terminating this process.



WORKAROUND
Run the entire INSERT..EXEC statement within a dynamic EXECUTE statement, for example:

EXECUTE ('INSERT INTO t1 EXEC ("SELECT a FROM t2")')



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: Transact-SQL EXECUTE

Keywords: kbbug KB152805

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.