Click here to Skip to main content
12,828,476 members (47,024 online)
   

Database

 
AnswerRe: Book recommendation for learning SQL Pin
Simon_Whale30-Jan-13 6:46
memberSimon_Whale30-Jan-13 6:46 
AnswerRe: Book recommendation for learning SQL Pin
djj5530-Jan-13 7:33
memberdjj5530-Jan-13 7:33 
AnswerRe: Book recommendation for learning SQL Pin
gvprabu21-Feb-13 0:09
membergvprabu21-Feb-13 0:09 
QuestionCan we delete old records from aspstatetempsessions table? Pin
manikantaer29-Jan-13 18:43
membermanikantaer29-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? Pin
thatraja4-Oct-13 21:46
mvpthatraja4-Oct-13 21:46 
Questioncontrol AVG cost and close stock Pin
kornkimhour29-Jan-13 16:13
memberkornkimhour29-Jan-13 16:13 
AnswerRe: control AVG cost and close stock Pin
thatraja4-Oct-13 21:50
mvpthatraja4-Oct-13 21:50 
QuestionMySQL Table Lock Question Pin
Richard Andrew x6429-Jan-13 13:46
memberRichard Andrew x6429-Jan-13 13:46 
AnswerRe: MySQL Table Lock Question Pin
Jörgen Andersson30-Jan-13 11:34
memberJörgen Andersson30-Jan-13 11:34 
QuestionSQL Update Pin
mrfalk29-Jan-13 12:24
membermrfalk29-Jan-13 12:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    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
Web01 | 2.8.170326.1 | Last Updated 28 Mar 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid