BUG: INSERT...EXEC of TEXT/IMAGE value may cause 702 (152805)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug KB152805 |
|---|
|