Using a SQL DB for session state.

[Geraldine]

I have encountered a problem when I restart a SQL server I lose my session
variables for ASP.NET

It seems that the Temp table cannot be used after the re-boot ...

Is there a way to fix this ?


// Geri

 

[Aidan Glendye]

Geri,

If you review the following microsoft article it details
the scripts required to create a database to store the
session state in. The default location for storing
session is within temp db which is cleared out when you
restart sql server.

http://support.microsoft.com/default.aspx?scid=kb;en-
us;311209

Hope this helps.

Aidan