We are running into these errors frequently (DB-LIB 10024 & 10007) on our production SQL Server. We are at Microsoft SQL Server version 8.00.760(SP3) running on Windows 2000. Server has got 3G Memory. We don't see any errors in the database error log. The bad thing is that this error kicks the user back to the main screen and they need to start over. Each time a user experienced this error it ranged from 1.5minutes to 4.5 minutes. The database has been defragged recently.
Any help is greatly appreciated in resolving this.