November 16, 2010 at 9:33 am
WE experecince this probelm now and then but i dont find any information in the sql or windows logs and I am sure we didtnt restart any service or killed any session, how can find the exact cause, this is very annoying as we lose the work we do in a sql session. Thanks.
Msg 64, Level 20, State 0, Line 0
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)
November 16, 2010 at 11:05 am
It means you lost the connection. Could be anything from a bad cat-5 cable to a faulty router, any number of things.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 16, 2010 at 2:09 pm
November 16, 2010 at 2:52 pm
Only nothing to worry about if it's not a hardware problem that's going to get worse. I'd at least run diagnostics on that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply