Click here to Skip to main content
       

Database

 
AnswerRe: What happens with auto-incremented value on rollback? PinmemberShameel30-Jan-13 4:15 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 6:45 
AnswerRe: What happens with auto-incremented value on rollback? Pinmemberi.j.russell30-Jan-13 5:37 
GeneralRe: What happens with auto-incremented value on rollback? Pinmemberpiticcotoc30-Jan-13 6:41 
AnswerRe: What happens with auto-incremented value on rollback? PinmemberMycroft Holmes30-Jan-13 12:44 
GeneralRe: What happens with auto-incremented value on rollback? PinmemberPIEBALDconsult31-Jan-13 4:40 
AnswerRe: What happens with auto-incremented value on rollback? Pinmembergvprabu21-Feb-13 0:02 
QuestionBook recommendation for learning SQL PinmemberLloyd Atkinson29-Jan-13 19:33 
AnswerRe: Book recommendation for learning SQL PinmemberJörgen Andersson30-Jan-13 1:52 
AnswerRe: Book recommendation for learning SQL Pinmemberi.j.russell30-Jan-13 5:34 
AnswerRe: Book recommendation for learning SQL PinmemberSimon_Whale30-Jan-13 6:46 
AnswerRe: Book recommendation for learning SQL Pinmemberdjj5530-Jan-13 7:33 
AnswerRe: Book recommendation for learning SQL Pinmembergvprabu21-Feb-13 0:09 
QuestionCan we delete old records from aspstatetempsessions table? Pinmembermanikantaer29-Jan-13 18: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
AnswerRe: Can we delete old records from aspstatetempsessions table? Pinmvpthatraja4-Oct-13 21:46 
Questioncontrol AVG cost and close stock Pinmemberkornkimhour29-Jan-13 16:13 
AnswerRe: control AVG cost and close stock Pinmvpthatraja4-Oct-13 21:50 
QuestionMySQL Table Lock Question PinmemberRichard Andrew x6429-Jan-13 13:46 
AnswerRe: MySQL Table Lock Question PinmemberJörgen Andersson30-Jan-13 11:34 
QuestionSQL Update Pinmembermrfalk29-Jan-13 12:24 
AnswerRe: SQL Update PinmemberPIEBALDconsult29-Jan-13 12:47 
GeneralRe: SQL Update Pinmembermrfalk29-Jan-13 13:07 
AnswerRe: SQL Update PinmemberMichael Potter29-Jan-13 12:50 
GeneralRe: SQL Update PinmemberPIEBALDconsult29-Jan-13 12:59 
GeneralRe: SQL Update PinmemberMycroft Holmes29-Jan-13 13:09 
GeneralRe: SQL Update Pinmembermrfalk29-Jan-13 13:17 
GeneralRe: SQL Update PinmemberPIEBALDconsult29-Jan-13 13:27 
GeneralRe: SQL Update PinmemberMycroft Holmes29-Jan-13 14:49 
GeneralRe: SQL Update PinmemberPIEBALDconsult29-Jan-13 13:20 
GeneralRe: SQL Update PinmemberMycroft Holmes29-Jan-13 14:54 
GeneralRe: SQL Update Pinmemberjschell29-Jan-13 15:13 
GeneralRe: SQL Update PinmemberMichael Potter30-Jan-13 5:28 
GeneralRe: SQL Update PinmemberPIEBALDconsult30-Jan-13 6:05 
GeneralRe: SQL Update Pinmemberjschell30-Jan-13 8:58 
GeneralRe: SQL Update PinmemberPIEBALDconsult30-Jan-13 9:40 
GeneralRe: SQL Update PinmemberMichael Potter31-Jan-13 4:57 
GeneralRe: SQL Update PinmemberPIEBALDconsult31-Jan-13 5:05 
GeneralRe: SQL Update Pinmemberjschell31-Jan-13 9:01 
AnswerRe: SQL Update PinmemberPIEBALDconsult29-Jan-13 14:22 
AnswerRe: SQL Update PinmemberJörgen Andersson30-Jan-13 2:21 
AnswerRe: SQL Update Pinmembermrfalk30-Jan-13 7:20 
QuestionDatabase backup size Pinmembersavbace28-Jan-13 23:45 
AnswerRe: Database backup size PinmemberRichard Deeming29-Jan-13 2:21 
QuestionSQL Server 2005 Express running slow ? PinmemberMember 245846728-Jan-13 16:56 
AnswerRe: SQL Server 2005 Express running slow ? PinmemberPIEBALDconsult28-Jan-13 17:11 
AnswerRe: SQL Server 2005 Express running slow ? PinmemberMycroft Holmes28-Jan-13 18:02 
AnswerRe: SQL Server 2005 Express running slow ? PinmemberJOAT-MON29-Jan-13 12:09 
QuestionCombining Data From Temp Tables PinmemberMatt U.28-Jan-13 9:46 
AnswerRe: Combining Data From Temp Tables PinmemberDavid Mujica28-Jan-13 10:13 
GeneralRe: Combining Data From Temp Tables PinmemberMatt U.28-Jan-13 10:54 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

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


Advertise | Privacy | Mobile
Web03 | 2.8.141216.1 | Last Updated 18 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid