I am getting lots of the below errors in my order entry system recently with no explainable cause.
[DBNETLIB][ConnectionWrite (send()).]General network error. Check your network documentation.
While i guess this could be a network hub failing or something in the network I am assuming these are being caused by SQL server. My course of action is to install the service packs in my SQL2000 server. Currently i'm running version 8.00.194 on Windows NT 5.0 (Build 2195: Service Pack 4). I have lots of stored procedures that my VB6 order entry frontend and reporting system uses. Is there any known problems with going from no service packs to SP4? I plan on running a full backup of all user db's and scripting out all jobs before installing SP4.