Microsoft KB Archive/193640

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.