Solved

"Connection Broken" Error

Posted on 2001-07-06
5
1,749 Views
Last Modified: 2007-11-27
(I)
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

Connection Broken
==================================================


(II)
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
0
Comment
Question by:sachinkas
5 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 40 total points
ID: 6259837
try to add the command <UPDATE STATISTICS>  or the sp_updatestats stored procedure before your command

0
 
LVL 1

Author Comment

by:sachinkas
ID: 6259991
Hi Angell,
Thanx for the reply. I will try it and run the job today night. This thing rarely happens so I wont know if it has worked or not. However if it works I will award u.
0
 
LVL 4

Assisted Solution

by:TheSpirit
TheSpirit earned 35 total points
ID: 6262877
Oh boy have you got problems !
I have seen 605 errors before, they are generally bad news in that they indicate some form of data corruption. This type of error is a page linkage error so on some selects it will not appear, however on selects that touch all rows they will come up. The first step should be to take a dump of the database and also file level copy. Next identify which table/object has the problem, sometimes the error will appear in an index, if it does just drop the index and re-create it (dbcc reindex might work ?). If it does turn out to be a corruption in the table you have a couple of options 1) Restore to a known good backup 2) Try and save the data from the table, this can be done in a couple of ways, using BCP to copy the data into a file and then import it back into another table, or use select into to move the data into a new table. You will more than likley not get all of the data out of the table, but you can improve things by selecting ascending and descending, to approach the corruption from both sides. Sometimes it is worth using an index hint on the select into to try and get the data that way.

You need to be using dbcc checkdb and checktable but you should have the database in single user mode before running these.

You don't say which service pack you are running, best to run sp5a or the later rollup version.
0
 

Expert Comment

by:CleanupPing
ID: 9282080
sachinkas:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Granting access to Microsoft SQL Server 17 26
ASP SQL Syntax Duplicate Key 7 66
SQL server 2008 SP4 29 33
SQL Server memory Issue 7 74
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now