BUG: Startup Procedure Fails Selecting TEXT/IMAGE Data (193640)
The information in this article applies to:
This article was previously published under Q193640
BUG #: 18330 (SQLBUG_65)
SYMPTOMS
A stored procedure that returns data including a TEXT/IMAGE field causes
the following error in the error log when the stored procedure is executed
as a startup stored procedure:
TEXT and IMAGE datatypes require DBLIB version 4.0 or greater.
The data that should be returned by the statement in the stored procedure
returning the TEXT/IMAGE data fails, and that data is not cached into
memory.
WORKAROUND
To work around this problem, try one of the following:
- Do not use the startup stored procedure; an alternative is to use a
scheduled task to run the procedure at an appropriate time.
-or-
- Omit the TEXT/IMAGE column(s) from the SELECT list for the startup
stored procedure.
-or-
- Write the stored procedure so that the TEXT/IMAGE data is not returned.
For example, if the intent is to cache the TEXT/IMAGE data into memory,
use a SELECT INTO statement to put the data in a temporary table. This
does not return the data to the executing spid, so the problem does not
occur.
STATUS
Microsoft has confirmed this to be a problem in SQL Server version 6.5.
| Modification Type: | Minor | Last Reviewed: | 3/14/2005 |
|---|
| Keywords: | kbBug KB193640 |
|---|
|