"Connection Broken" Error
Posted on 2001-07-06
I have some scheduling jobs which runs on nightly basis.
When there is a query like say "select max" or "select count(*)" for some tables sometimes they give an error:
Changed language setting to us_english.
Server: Msg 21, Level 21, State 1, Line 1
Warning: Fatal error 605 occurred at Jul 6 2001 9:11AM
Also while truncating a table the error is:
DB-Library: Db-library network communciations layer not loaded.
These errors also come when I run the query in query analyzer. And the problem is that they come only some times not always. To remove the error I have to remove the table and rebuild it.
I have SQL Server 6.5 on NT 4