ronleclairjr
04-14-2006, 08:35 AM
We are using the ASPStateTempSessions to store our session data. We are looking to archive the data for some time rather than delete it. I would like to set up a stored procedure of some kind to execute at a given time to archive the data. The session data is serialized in the SQL Server table. Is there anyway within SQL Server to deserialize this data and store it by its key/value data.
The column in the source table is:
SessionId char(32)
SessionItemShort varbinary(7000)
Columns in destination table are:
SessionId char(32)
SessionKey varchar(50)
SessionValue varchar(300)
Thanks in advance for any help!!
The column in the source table is:
SessionId char(32)
SessionItemShort varbinary(7000)
Columns in destination table are:
SessionId char(32)
SessionKey varchar(50)
SessionValue varchar(300)
Thanks in advance for any help!!