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

• Microsoft SQL Server version 7.0

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.

Additional query words: prodsql XP

Keywords          : 
Version           : WINNT:7.0
Platform          : winnt 
Issue type        : kbinfo 

Last Reviewed: April 21, 1999