Application and Session state stored in SQL Server

microsoft.public.dotnet.framework.aspnet

25 Nov 2005 6:47 AM

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) ?

25 Nov 2005 7:49 AM

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]

Show quoteHide quote

"Michael" <huanlin.t***@gmail.com> wrote in message
news:uGbBnwY8FHA.3636@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) ?
>

Are all your drivers up to date? click for free checkup

26 Nov 2005 4:15 AM

Michael

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

Michael

Show quoteHide quote

> 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]
>