Using a SQL DB for session state.

  • Thread starter Thread starter Geraldine
  • Start date Start date
G

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Session State Sql with webDev.webserver SLOW 2
A way to get back lost session values 3
Installing ASP.Net SQL Session State on IIS7 1
Moving from In Process Session to SQL Server Session State 1
How can a different web page (aspx) access anothers session variab 2
Question about SQLServer Session State Management 2
Is "InProc" suitable for production Session State? 13
Session State 1

Back
Top