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


more ▼

asked Apr 06, 2010 at 09:28 AM in Default

avatar image

33 2 2 4

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Apr 06, 2010 at 09:37 AM

avatar image

Grant Fritchey ♦♦
137k 20 46 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Apr 06, 2010 at 09:28 AM

Seen: 3585 times

Last Updated: Apr 06, 2010 at 09:38 AM

Copyright 2018 Redgate Software. Privacy Policy