Click here to Skip to main content
15,917,928 members
Home / Discussions / Database
   

Database

 
AnswerRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius18-Jul-08 5:29
mentorWendelius18-Jul-08 5:29 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl21-Jul-08 6:54
dasha_pl21-Jul-08 6:54 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius21-Jul-08 8:29
mentorWendelius21-Jul-08 8:29 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl21-Jul-08 20:27
dasha_pl21-Jul-08 20:27 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl22-Jul-08 1:52
dasha_pl22-Jul-08 1:52 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius22-Jul-08 5:33
mentorWendelius22-Jul-08 5:33 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
dasha_pl22-Jul-08 21:44
dasha_pl22-Jul-08 21:44 
GeneralRe: An error encountered when ms sql server 2005 have to send a lots of data Pin
Wendelius23-Jul-08 5:48
mentorWendelius23-Jul-08 5:48 
Ok,

Didn't yet have any specific idea.

Is the connection open all the time during a single request? I mean that there is no way that the connection could be closed or disposed by your code before the failing statement?

Could you:
- wire StateChange event for the connection
- every time the state changes, write to a log file (or similar) both CurrentState and OriginalState from event arguments
- wire InfoMessage event for the connection
- write every element from Errors collection from message event argument. Also write Message and Source
- wire Disposed event for the connection
- when Disposed occurs, write info about this to the log file
- write to the log file every time you get data context from httpcontext
- write to the log file every time you call open method on the sql connection
- write to the log file every time you execute the statements (especially the failing one)
- write to the log file every time you call close method on the sql connection

This should give a good output which shows the order how things are happening and some extra info what is actually happening.


Another thing that I'm thinking of is that why this doesn't happen on your local SQL Server but happens if you try to use SQL Server on another server. This could be because:
- network problems (packets are occasionally not delivered)
- the server under heavy stress and cannot respond
What do you think, could the reason be in those?


Mika
QuestionExcel Query [modified] Pin
Sunil Wise17-Jul-08 21:01
professionalSunil Wise17-Jul-08 21:01 
AnswerRe: Excel Query [modified] Pin
Sunil Wise17-Jul-08 21:32
professionalSunil Wise17-Jul-08 21:32 
QuestionHow to insert data from MS SQL server in MS EXCEL Sheet? Pin
guriqbal8717-Jul-08 4:22
guriqbal8717-Jul-08 4:22 
AnswerRe: How to insert data from MS SQL server in MS EXCEL Sheet? Pin
leoinfo17-Jul-08 5:17
leoinfo17-Jul-08 5:17 
GeneralRe: How to insert data from MS SQL server in MS EXCEL Sheet? Pin
guriqbal8720-Jul-08 20:50
guriqbal8720-Jul-08 20:50 
AnswerCross Post Pin
Paul Conrad17-Jul-08 16:51
professionalPaul Conrad17-Jul-08 16:51 
QuestionSending Email Pin
jonhbt17-Jul-08 3:38
jonhbt17-Jul-08 3:38 
AnswerRe: Sending Email Pin
Wendelius17-Jul-08 8:06
mentorWendelius17-Jul-08 8:06 
QuestionNested Cursor loop problem Pin
Member 387988117-Jul-08 3:25
Member 387988117-Jul-08 3:25 
AnswerRe: Nested Cursor loop problem Pin
Mark J. Miller17-Jul-08 9:27
Mark J. Miller17-Jul-08 9:27 
GeneralRe: Nested Cursor loop problem [modified] Pin
Member 387988117-Jul-08 19:59
Member 387988117-Jul-08 19:59 
GeneralRe: Nested Cursor loop problem Pin
Mark J. Miller18-Jul-08 5:20
Mark J. Miller18-Jul-08 5:20 
QuestionCompact database not working Pin
krishnan.s17-Jul-08 2:41
krishnan.s17-Jul-08 2:41 
AnswerRe: Compact database not working Pin
Paul Conrad17-Jul-08 16:51
professionalPaul Conrad17-Jul-08 16:51 
QuestionNot In operation? Pin
Member 387988117-Jul-08 1:03
Member 387988117-Jul-08 1:03 
AnswerRe: Not In operation? Pin
TheFM23417-Jul-08 3:00
TheFM23417-Jul-08 3:00 
GeneralRe: Not In operation? Pin
Member 387988117-Jul-08 3:09
Member 387988117-Jul-08 3:09 

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.