24th July 20:56
general network error
I am working on sql server 2000.
We have a job that runs every 30 mins every day. It has
been behaving very well. The only time it failed was
yesterday at 10:00am. When I viewed the job history, it
showed the following message:
Executed as user: blahblah\sql_admin. ConnectionRead (recv
()). [SQLSTATE 01000] (Message 10054) General network
error. Check your network do***entation. [SQLSTATE 08S01]
(Error 11). The step failed.
General network error usually indicate that there is a
network connection failure. But this specific job/stored
procedure is not pulling data from any other server but
from local table. (Message 10054) indicating BCP overflow
certain column definition, but we are not doing BCP
Could this message mean that there are too many disk I/O
going on at that time, and this job was waiting too long
in idle and failed?
Or could that be a logon info issue?
Any suggestion will be greatly appreciated.