INF: INSERT EXEC of Text/Image/Ntext from XP Is Not Supported (198487)


The information in this article applies to:

  • Microsoft SQL Server 7.0
This article was previously published under Q198487

SUMMARY

Using the INSERT ... EXEC syntax to insert text, ntext, or image data is not supported with SQL Server extended stored procedures. This limitation is not documented in SQL Server 7.0 Books Online.

MORE INFORMATION

The INSERT ... EXEC syntax is useful to insert data into a table based on the execution of a stored procedure or an extended stored procedure. If an extended stored procedure returns data as a text, ntext, or image datatype, no rows will be inserted. This restriction does not apply to standard stored procedures.

SQL Server 6.x Books Online contains the following information which helps explain the limitation:

With Open Data Services, you can describe and return data of text and image datatypes. However, because Open Data Services does not support pointers, it can not support DB-Library functions that require pointers (for example, dbmoretext, dbwritetext, and dbtxtptr). DB-Library clients can bind and receive data of these types as long as they receive them using the non-text DB-Library functions.

Modification Type:MajorLast Reviewed:4/23/1999
Keywords:kbinfo KB198487
©2002 Microsoft Corporation. All rights reserved.