Recently, we've been getting the following message when running a job in sql 2000 that executes and sp but not all the time.
"ConnectionCheckForData (CheckforData()). [SQLSTATE 01000] (Message 10054) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed.:
It's mostly in this one sp that takes a couple of minutes to run but it's not all the time and occasionally, it happens in other jobs. Sometimes, just running it again works, sometimes stopping and starting sql service works and the sp always works when running through query analyzer.
Not much at all on Microsoft's site about this or anywhere else I can find so far. Any ideas? Thanks, Joe
"ConnectionCheckForData (CheckforData()). [SQLSTATE 01000] (Message 10054) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed.:
It's mostly in this one sp that takes a couple of minutes to run but it's not all the time and occasionally, it happens in other jobs. Sometimes, just running it again works, sometimes stopping and starting sql service works and the sp always works when running through query analyzer.
Not much at all on Microsoft's site about this or anywhere else I can find so far. Any ideas? Thanks, Joe