We have SQL SERVER 2000 Enterprise Edition with Service Pack 2. It is running on Windows 2003 Server R2 Standard Edition with Service Pack 2.
It runs several databases and Microsoft Dynamics SL Application. The main database is about 80 GB. Recently , the application users have been getting "Sql server Error 10054 - Possible Network error : write to Sql Server Failed. General Network error." . All users on the application get locked or disconnected from the server ; they have to terminate the task , and login again into the application. This error occurs only on those workstations which have logged on to the main database that is 80GB. The users of other databases on same server are not affected. So far, we have already verified that there is no problem with the switch, network card or server. We have replace the network card on the server. DBCC Checkdb returned 0 errors. There is no particular process or application screen that could be identified as a cause of this problem. The error repeats several times in the day.