An inconsistency was detected during an internal operation in database

Question

question

Mumin-FSL-BD asked Apr 6, '10

An inconsistency was detected during an internal operation in database

I have a table and while i tried to retrive data from the table using select statement, query returns some data and then generate an error message like 'An inconsistency was detected during an internal operation in database'. Then I go through my data and found some corrupted data in some column which is not readable in normal query. Then I use convert statement and retrive the data. but still now it's not possible to retrive all data. In my findings, i reveal that, in some column, some data inserted which is actually greater than the length defined in column in table structure. basically you can't insert any record containing the value greater than the length defined. Now my question is how it is possible to insert this kind of such data? And am i Able to retrive my all data from the corrupted table?

i appreciate any help in this regard.

thanks in advance

Mumin

sql-server-2005 sql dbcc corruption

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2010-04-06T09:37:50Z

Grant Fritchey answered Apr 6, '10

First thing, you need to run DBCC CHECKDB on that database. That will perform a consistency check and identify exactly where any errors are. With that information you can begin to fix the problem. If you need more information on DBCC and corruption, the single best source for that information is Paul Randal. There is good information in the Books Online too, but I generally go to Paul as the source.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question