Re: VJs Tip Of The Day

[VishalRJoshi]

New Message on dotNET User Group Hyd VJs Tip Of The Day Reply   Reply to Sender   Recommend Message 16 in Discussion From: VishalRJoshi SQL Server Session State Does It Again Well did you wonder yesterday, that if your session data was stored in permanent tables on SQL server and there would be "n" number of sessions running for your application all the time how much data would get collected in the SQL Server???... If you thought about it, I really appreciate... So, there has to be a mechanism to clean this data every once in a while right!!... And of course there is... When SQL Server support for session gets installed a job to delete the expired session is also installed, this job runs every minute and is called ASPState_Job_DeleteExpiredSessions...; It requires SQLServerAgent service to be running in order to work... Vishal Joshi Microsoft MVP .Net If You Think YOU CAN... You Can... http://VishalJoshi.Blogspot.com http://www.microsoft.com/india/mvp/indiamvp.aspx http://groups.msn.com/ChennaiNetUserGroup http://groups.msn.com/CNUG-DAM http://groups.msn.com/NetBloomingtonUserGroup PS: To visit earlier tips click on the right side "Archives" menu on my blog site... View other groups in this category. Also on MSN: Start Chatting | Listen to Music | House & Home | Try Online Dating | Daily Horoscopes To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from dotNET User Group Hyd.