Database

View All Threads First Prev Next

Can we delete old records from aspstatetempsessions table? manikantaer29-Jan-13 17:43 manikantaer 29-Jan-13 17:43  Hi.. Recently i created Session State in my project, code is here.. <sessionState mode="SQLServer" allowCustomSqlDatabase="true" sqlConnectionString="Data Source=ADMIN-9F8C57749\SQLEXPRESS;Initial Catalog=kecbliss;Integrated Security=True" timeout="60" stateNetworkTimeout="60"> </sessionState> the problem is day by day aspstatetempsessions table is becoming big so my question is 1.can i delete previous days records from aspstatetempsessions? 2.How to achieve this without affecting to project ? project details front end ASP.NET Back end MS SQL Server Re: Can we delete old records from aspstatetempsessions table? thatraja4-Oct-13 20:46 thatraja 4-Oct-13 20:46  You got answer there[^]. FYI Potential enhancements to ASPState[^] Where Are ASPStateTempApplications and ASPStateTempSessions Tables?[^] thatraja FREE Code Conversion VB6 ASP VB.NET C# ASP.NET C++ JAVA PHP DELPHI ColdFusion HTML Marquee & its alternatives Nobody remains a virgin, Life screws everyone

Last Visit: 31-Dec-99 18:00     Last Update: 26-Apr-24 12:31 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.