SessionState Mode=SQLServer and Session.Abandon

Discussion in 'ASP .Net' started by =?Utf-8?B?RWQ=?=, Sep 20, 2006.

  1. I am trying out SessionState with Mode=SQLServer. I have my
    code run Session.Abandon, but the session entry in the table
    ASPStateTempSessions is still there? I was expecting that Session.Abandon
    would remove the Session from the table. Is their a different method I
    should use
    to remove the Session table entry? Is the only way the session will be
    removed from the table, is when the session Expires? I notice that there is a
    SQL job
    that deletes expired sessions, but would it not be better if this entry is
    removed
    immediately on logout?

    Thank you

    Ed
    =?Utf-8?B?RWQ=?=, Sep 20, 2006
    #1
    1. Advertising

  2. you are correct, the sql job is the only deleter.

    -- bruce (sqlwork.com)


    "Ed" <> wrote in message
    news:...
    >I am trying out SessionState with Mode=SQLServer. I have my
    > code run Session.Abandon, but the session entry in the table
    > ASPStateTempSessions is still there? I was expecting that
    > Session.Abandon
    > would remove the Session from the table. Is their a different method I
    > should use
    > to remove the Session table entry? Is the only way the session will be
    > removed from the table, is when the session Expires? I notice that there
    > is a
    > SQL job
    > that deletes expired sessions, but would it not be better if this entry is
    > removed
    > immediately on logout?
    >
    > Thank you
    >
    > Ed
    >
    bruce barker \(sqlwork.com\), Sep 20, 2006
    #2
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Kristofer Liljeblad
    Replies:
    0
    Views:
    591
    Kristofer Liljeblad
    Jun 30, 2003
  2. TSelvan
    Replies:
    1
    Views:
    1,768
    Natty Gur
    Jul 30, 2003
  3. Phl
    Replies:
    0
    Views:
    366
  4. =?Utf-8?B?Q3JhaWc=?=
    Replies:
    1
    Views:
    485
    Robbe Morris [C# MVP]
    Jun 24, 2005
  5. Moe Sisko
    Replies:
    3
    Views:
    1,677
    Moe Sisko
    Apr 29, 2008
Loading...

Share This Page