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

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.