March 25, 2014 at 8:42 am
We're on sql 2012 and use the Aspstate database and associated stored procedures to store browser session state info. Has anyone heard of an update to this that does not use READTEXT? Not sure when we might move to the next version of sql server but READTEXT may not work then. ( the suggestion is to use substring instead ).
March 25, 2014 at 10:00 am
READTEXT is associated with the TEXT, NTEXT, and IMAGE data types. I believe what you need to do is migrate from those data types to the VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) data types.
March 25, 2014 at 10:35 am
Thanks Lynn. Yes, in at least one of the aspstate stored procedures, READTEXT is touching an IMAGE column. I don't know when or if we will migrate to the next version of sql server ( 2014? ) but it would be nice to find either a new version of aspstate ( tables and procs ) that would continue to function, or an alternative. We looked at something called appfabric but development abandoned it after some testing.
READTEXT [ASPState].dbo.ASPStateTempSessions.SessionItemLong @textptr 0 @length
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply