Click here to Skip to main content
12,243,738 members (39,960 online)
   

Database

 
AnswerRe: What happens with auto-incremented value on rollback? Pin
gvprabu21-Feb-13 0:02
membergvprabu21-Feb-13 0:02 
QuestionBook recommendation for learning SQL Pin
Lloyd Atkinson29-Jan-13 19:33
memberLloyd Atkinson29-Jan-13 19:33 
AnswerRe: Book recommendation for learning SQL Pin
Jörgen Andersson30-Jan-13 1:52
memberJörgen Andersson30-Jan-13 1:52 
AnswerRe: Book recommendation for learning SQL Pin
i.j.russell30-Jan-13 5:34
memberi.j.russell30-Jan-13 5:34 
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 
AnswerRe: SQL Update Pin
PIEBALDconsult29-Jan-13 12:47
memberPIEBALDconsult29-Jan-13 12:47 
GeneralRe: SQL Update Pin
mrfalk29-Jan-13 13:07
membermrfalk29-Jan-13 13:07 
AnswerRe: SQL Update Pin
Michael Potter29-Jan-13 12:50
memberMichael Potter29-Jan-13 12:50 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 12:59
memberPIEBALDconsult29-Jan-13 12:59 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 13:09
memberMycroft Holmes29-Jan-13 13:09 
GeneralRe: SQL Update Pin
mrfalk29-Jan-13 13:17
membermrfalk29-Jan-13 13:17 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 13:27
memberPIEBALDconsult29-Jan-13 13:27 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 14:49
memberMycroft Holmes29-Jan-13 14:49 
GeneralRe: SQL Update Pin
PIEBALDconsult29-Jan-13 13:20
memberPIEBALDconsult29-Jan-13 13:20 
GeneralRe: SQL Update Pin
Mycroft Holmes29-Jan-13 14:54
memberMycroft Holmes29-Jan-13 14:54 
GeneralRe: SQL Update Pin
jschell29-Jan-13 15:13
memberjschell29-Jan-13 15:13 

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
Web02 | 2.8.160426.1 | Last Updated 30 Apr 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid