Hi Guys I'm running a DBCC CheckDB on one of our databases and I'm getting
some errors that I'm not sure how to fix or get rid of.

I was attempting to look for the invalid values in the tables but unable to
find them.

Also when I try to update Statistics on the table that has the 3rd error i
get the following error
Server: Msg 3628, Level 16, State 1, Line 1
A floating point exception occurred in the user process. Current transaction
is canceled.

Error 1 is from a table that does not have a column of latMax, errors 2, and
3 are from the same table. However SeismicSaleID is an int column not a
float
Here are the 3 errors

1)Server: Msg 2570, Level 16, State 1, Line 1
Warning: Page (1:6701214), slot 0 in Object 1824725553 Index 0 Column latMax
value -1.#INF is out of range for data type "float". Update column to a
legal value.
2)Server: Msg 2570, Level 16, State 1, Line 1
Warning: Page (1:2412667), slot 1 in Object 1824725553 Index 16 Column
SeismicSaleID value -1.#INF is out of range for data type "float". Update
column to a legal value.
3)Server: Msg 8976, Level 16, State 1, Line 1
Table error: Object ID 1824725553, index ID 1. Page (1:6701214) was not seen
in the scan although its parent (1:6701233) and previous (1:6701213) refer
to it. Check any previous errors.



Nam Nguyen
Drilling Info, Inc.
Data Analyst/Database Administrator
512-784-0564
http:www.drillinginfo.com






MS Sql Server LazyDBA home page