BUG: Startup Procedure Fails Selecting TEXT/IMAGE Data
Article ID: 193640
Article Last Modified on 3/14/2005
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
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.
Additional query words: st proc stproc errorlog
Keywords: kbbug KB193640