FIX: Access to TEXT Column of Temp Table Inside SP May Cause AV

• Microsoft SQL Server version 6.5

SYMPTOMS

Executing a READTEXT, WRITETEXT, or UPDATETEXT statement against a TEXT/IMAGE column of a temporary table inside a stored procedure will cause a handled access violation if both of the following conditions are true:

• The temporary table was created outside the stored procedure.
  
  -and-



• At the time the stored procedure is executed, the temporary table is different from the one at the time when the stored procedure was created.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

Additional query words: prodsqltemp st proc sp av sp5

Keywords          : kbbug6.50 kbfix6.50.SP5 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: May 4, 1999