Hi,
Can anyone share some thoughts about t_web tables and how often they maintain these (and what they do)?
I did see the Knowledgebase article "Removing data from the Web Session tables".
After attempting to do some cleaning, I admit defeat. (I'm not a mean SQL programmer)
One problem I was having was due to a REFERENCE constraint between tables
The DELETE statement conflicted with the REFERENCE constraint "FK_T_WEB_SESSION_VARIABLE_t_web_session". The conflict occurred in database "impresario", table "dbo.t_web_session_Variable", column 'SessionKey'.
Cheers
Damien
Hi Damien,
Good day.
I have checked those two tables. If you really want to clean up the table, you need to delete the item in t_web_session_Variable first, then delete items in t_web_session_Session. that is all.
you cannot delete a PK item when it is used as FK in another table.
Have fun.
Ben