Hi all,
How to avoid automatically dropping TempDB session tables when server is rebooting.
We are maintaing session state in sql server, when sql server is restarting the below two tables are dropping. we need to create them again. Is there any solution for this to avoid for creating these tables again and again?
TempDB Session Tables are
1. dbo.ASPStateTempSessions
2. dbo.ASPStateTempApplications
thanks in advance.
Hari