sessionstate = SQLServer

[Wardeaux]

I'm wanting to use SQL to store session variables. This works well because
it maintains session variables even though a session times out but the
browser is still open
When a session.entry in the sql table ASPStateTempSessions is automatically
removed whenever the browser calls "Session.Abandon"... this is good, but
the session entry is left when the browser is closed by the user thus ending
the session. How do the entries eventually get cleaned up in the
ASPStateTempSessions table? I can't just have them accumulating over the
years...

anyone use this feature before and has a solution?

MTIA
wardeaux

[Joris Dobbelsteen]

Use the Session_End (or simulair) event. I don't know whether its called
always, but it should be...

Additionally you can add a date to the table when it was last updated and
periodically scrave the database for really old data (which should exist
anyway).
You can use this mechanism to check whether the application actually does
its job.

- Joris

"Wardeaux" <wa******@bellsouth.net> wrote in message
news:uf*************@TK2MSFTNGP10.phx.gbl...

I'm wanting to use SQL to store session variables. This works well because it maintains session variables even though a session times out but the
browser is still open
When a session.entry in the sql table ASPStateTempSessions is automatically removed whenever the browser calls "Session.Abandon"... this is good, but
the session entry is left when the browser is closed by the user thus ending the session. How do the entries eventually get cleaned up in the
ASPStateTempSessions table? I can't just have them accumulating over the
years...

anyone use this feature before and has a solution?

MTIA
wardeaux

[Patrice]

AFAIK you should have a SQL Job that cleans up old data. Double check the
SQL scripts...

Patrice

--

"Wardeaux" <wa******@bellsouth.net> a écrit dans le message de
news:uf*************@TK2MSFTNGP10.phx.gbl...

I'm wanting to use SQL to store session variables. This works well because it maintains session variables even though a session times out but the
browser is still open
When a session.entry in the sql table ASPStateTempSessions is automatically removed whenever the browser calls "Session.Abandon"... this is good, but
the session entry is left when the browser is closed by the user thus ending the session. How do the entries eventually get cleaned up in the
ASPStateTempSessions table? I can't just have them accumulating over the
years...

anyone use this feature before and has a solution?

MTIA
wardeaux

[Wardeaux]

Patrice,
Thanks for the reply... I see a script "DeleteExpiredSessions" in the
ASPState db... does this get run automagically (if so... when) or do I need
to run/schedule this (if so... how)?
I'm only lightly familiar with SQL so any help is GREATLY appreciated! :)
MTIA
wardeaux
BTW, I'm not familiar with "AFAIK", what does that stand for?

"Patrice" <no****@nowhere.com> wrote in message
news:ud**************@tk2msftngp13.phx.gbl...

AFAIK you should have a SQL Job that cleans up old data. Double check the
SQL scripts...

Patrice

--

"Wardeaux" <wa******@bellsouth.net> a écrit dans le message de
news:uf*************@TK2MSFTNGP10.phx.gbl...

I'm wanting to use SQL to store session variables. This works well

because

it maintains session variables even though a session times out but the
browser is still open
When a session.entry in the sql table ASPStateTempSessions is

automatically

removed whenever the browser calls "Session.Abandon"... this is good, but the session entry is left when the browser is closed by the user thus

ending

the session. How do the entries eventually get cleaned up in the
ASPStateTempSessions table? I can't just have them accumulating over the years...

anyone use this feature before and has a solution?

MTIA
wardeaux

[Patrice]

AFAIK "As Far As I Know" (never used the SQL Server state).

Try :
http://www.dbazine.com/cook9.shtml

that seems to explain this quite well...

SQL Server Agent is likely not running.

--

"Wardeaux" <wa******@bellsouth.net> a écrit dans le message de
news:u8**************@TK2MSFTNGP10.phx.gbl...

Patrice,
Thanks for the reply... I see a script "DeleteExpiredSessions" in the
ASPState db... does this get run automagically (if so... when) or do I need to run/schedule this (if so... how)?
I'm only lightly familiar with SQL so any help is GREATLY appreciated! :)
MTIA
wardeaux
BTW, I'm not familiar with "AFAIK", what does that stand for?

"Patrice" <no****@nowhere.com> wrote in message
news:ud**************@tk2msftngp13.phx.gbl...

AFAIK you should have a SQL Job that cleans up old data. Double check the

SQL scripts...

Patrice

--

"Wardeaux" <wa******@bellsouth.net> a écrit dans le message de
news:uf*************@TK2MSFTNGP10.phx.gbl...

I'm wanting to use SQL to store session variables. This works well

because

it maintains session variables even though a session times out but the
browser is still open
When a session.entry in the sql table ASPStateTempSessions is

automatically

removed whenever the browser calls "Session.Abandon"... this is good,

but the session entry is left when the browser is closed by the user thus

ending

the session. How do the entries eventually get cleaned up in the
ASPStateTempSessions table? I can't just have them accumulating over the years...

anyone use this feature before and has a solution?

MTIA
wardeaux

[bruce barker]

generally its scheduled with SQLAgent. use sql enterprise manager under
magament->sql server agent ->jobs you should find the sp scheduled to run.
if not add it.

-- bruce (sqlwork.com)

"Wardeaux" <wa******@bellsouth.net> wrote in message
news:u8**************@TK2MSFTNGP10.phx.gbl...

Patrice,
Thanks for the reply... I see a script "DeleteExpiredSessions" in the
ASPState db... does this get run automagically (if so... when) or do I need to run/schedule this (if so... how)?
I'm only lightly familiar with SQL so any help is GREATLY appreciated! :)
MTIA
wardeaux
BTW, I'm not familiar with "AFAIK", what does that stand for?

"Patrice" <no****@nowhere.com> wrote in message
news:ud**************@tk2msftngp13.phx.gbl...

AFAIK you should have a SQL Job that cleans up old data. Double check the

SQL scripts...

Patrice

--

"Wardeaux" <wa******@bellsouth.net> a écrit dans le message de
news:uf*************@TK2MSFTNGP10.phx.gbl...

I'm wanting to use SQL to store session variables. This works well

because

it maintains session variables even though a session times out but the
browser is still open
When a session.entry in the sql table ASPStateTempSessions is

automatically

removed whenever the browser calls "Session.Abandon"... this is good,

but the session entry is left when the browser is closed by the user thus

ending

the session. How do the entries eventually get cleaned up in the
ASPStateTempSessions table? I can't just have them accumulating over the years...

anyone use this feature before and has a solution?

MTIA
wardeaux

[M. Posseth]

if you executed the SQL file as described in the documentation (MSDN or
70-305 / 70-315) the sql server agent wil start a clean job for expired
sessions


"bruce barker" <no***********@safeco.com> wrote in message
news:uE**************@TK2MSFTNGP09.phx.gbl...

generally its scheduled with SQLAgent. use sql enterprise manager under
magament->sql server agent ->jobs you should find the sp scheduled to run.
if not add it.

-- bruce (sqlwork.com)

"Wardeaux" <wa******@bellsouth.net> wrote in message
news:u8**************@TK2MSFTNGP10.phx.gbl...

Patrice,
Thanks for the reply... I see a script "DeleteExpiredSessions" in the

ASPState db... does this get run automagically (if so... when) or do I

need

to run/schedule this (if so... how)?
I'm only lightly familiar with SQL so any help is GREATLY appreciated! :) MTIA
wardeaux
BTW, I'm not familiar with "AFAIK", what does that stand for?

"Patrice" <no****@nowhere.com> wrote in message
news:ud**************@tk2msftngp13.phx.gbl...

AFAIK you should have a SQL Job that cleans up old data. Double check the SQL scripts...

Patrice

--

"Wardeaux" <wa******@bellsouth.net> a écrit dans le message de
news:uf*************@TK2MSFTNGP10.phx.gbl...
> I'm wanting to use SQL to store session variables. This works well
because
> it maintains session variables even though a session times out but the > browser is still open
> When a session.entry in the sql table ASPStateTempSessions is
automatically
> removed whenever the browser calls "Session.Abandon"... this is good, but

> the session entry is left when the browser is closed by the user

thus ending
> the session. How do the entries eventually get cleaned up in the
> ASPStateTempSessions table? I can't just have them accumulating

over the

> years...
>
> anyone use this feature before and has a solution?
>
> MTIA
> wardeaux
>
>