BUG: Insert .. Exec Fails Inside a Stored Procedure with Error 702 if the Table Contains a TEXT Column

ID: Q230196

The information in this article applies to:

BUG #: 18715 (SQLBUG_65)

SYMPTOMS

A stored procedure that performs an:


INSERT INTO <table_name> EXEC (...)

on a table that contains a text column will fail with the following error:

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.

Do not put the INSERT .. EXEC statement in a stored procedure when the table being inserted into contains a text column.

Microsoft has confirmed this to be a problem in SQL Server version 6.5.

The following script demonstrates the problem:


create table text_table
(col1 text)
go

create proc load_data
as
insert into text_table exec("select 'go'")
go

exec load_data
go

The following error occurs:

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.

Additional query words:

Keywords : kbSQLServ650bug
Version : winnt:6.5
Platform : winnt
Issue type : kbbug