BUG: Startup Procedure Fails Selecting TEXT/IMAGE Data

ID: Q193640

The information in this article applies to:

Microsoft SQL Server version 6.5

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 : SSrvAdmin SSrvStProc kbbug6.50
Version : WINNT:6.5
Platform : winnt
Issue type : kbbug