Discussion Locked

What can be done for the following error

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

While executing a query 'select * from tbl' from the query analyzer i got the message Attempt to fetch logical page 2382 in database 'dbtest' belongs to object '1424007584', not to object 'tbl'. DB-process failed. Connection Broken.

What can i donow?

i've searched in the sysobjects table with the id 1424007584 but no rows were returned.

5 replies

by nikki96

You don't give any specifics here on system, OS, DB type or schema. So, a guess - if it's trying to fetch 2382 pages, that may be too large for your system to handle. Stick a "where" clause in there to narrow the results and see what happens. If it can return less data, you may have too little memory for such a large dataset.

HTH
~nikki~

by joseph moore

I am going to take a guess and say you are running SQL Server 6.5.
If you are running 6.5, then you need to upgrade to Service Pack 5A for SQL Server 6.5
To get that service pack, go here:
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com/support/servicepacks/SQL/6.5/SP5a.asp
(please remove all spaces)

There were a bunch of problems in 6.5 that would cause the error you are getting. The last service pack took care of all of the documented errors, so hopefully itwill fix things for you.

hope this helps

This discussion is closed to new replies.