Application and Session state stored in SQL Server

[Michael]

Hi,
I know how to store Session state in SQL Server,
but I'm not sure if the Application state is also
stored in SQL Server.
There is a table named ASPStateTempApplications
in tempdb database, but it seems useless. I say this
because I reset IIS and see that application state is
reset.

Will application state be stored in SQL Server
(or state server) ?

[Ken Cox]

Hi Michael,

From the documentation, it looks like you can only store application state
in memory. However, you can include the start-up values in various places,
including the new the StaticObjects collection.

http://msdn2.microsoft.com/en-us/library/ms178594.aspx

Ken
Microsoft MVP [ASP.NET]
"Michael" <hu**********@gmail.com> wrote in message
news:uG**************@TK2MSFTNGP09.phx.gbl...

Hi,
I know how to store Session state in SQL Server,
but I'm not sure if the Application state is also
stored in SQL Server.
There is a table named ASPStateTempApplications
in tempdb database, but it seems useless. I say this
because I reset IIS and see that application state is
reset.

Will application state be stored in SQL Server
(or state server) ?

[Michael]

Hi Ken,
Thank you for the information, it's helpful :)

Michael

Hi Michael,

From the documentation, it looks like you can only store application state
in memory. However, you can include the start-up values in various places,
including the new the StaticObjects collection.

http://msdn2.microsoft.com/en-us/library/ms178594.aspx

Ken
Microsoft MVP [ASP.NET]