Manageing old SQLSession State RSS

• • Reply
  

  mattcase

  Member

  374 Points

  518 Posts

  Manageing old SQLSession State

  Feb 29, 2012 06:43 PM|LINK

  Hi,

  I am going to  implement SQLServer Session State for my application and I wanted to know two main things:

  1)  Does .Net manage the DB so that old sessions are deleted from the database after the session has expired?

  2)  If not, how would I go about deleting old session data from my database accross all tables?

  Thanks.

  sessionstate sqlserver

  Matt
• • Reply
  

  DarthSwian

  Star

  12771 Points

  2361 Posts

  Re: Manageing old SQLSession State

  Feb 29, 2012 06:47 PM|LINK

  The session provider does clean out those sessions, they don't live forever.

  Mark as answer if I helped.
  
  Seek and ye shall find or http://lmgtfy.com/
  • Marked as answer by mattcase on Mar 06, 2012 06:04 PM
• • Reply
  

  mattcase

  Member

  374 Points

  518 Posts

  Re: Manageing old SQLSession State

  Feb 29, 2012 07:08 PM|LINK

  Thanks for your reply.  How long before they are deleted?  Can I manually set this in the config file?

  Matt
• • Reply
  

  DarthSwian

  Star

  12771 Points

  2361 Posts

  Re: Manageing old SQLSession State

  Mar 01, 2012 02:10 PM|LINK

  <sessionState mode="SQLServer" allowCustomSqlDatabase="true" sqlConnectionString="YOURCONNECTIONSTRINGTOSQL" cookieless="false" timeout="60" />

  Mark as answer if I helped.
  
  Seek and ye shall find or http://lmgtfy.com/
  • Marked as answer by mattcase on Mar 06, 2012 06:04 PM