x

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

more ▼

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

Mumin-FSL-BD gravatar image

Mumin-FSL-BD
33 2 2 2

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

1 answer: sort newest

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

Grant Fritchey gravatar image

Grant Fritchey ♦♦
97.9k 19 21 74

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1943
x711
x47
x19

asked: Apr 06, 2010 at 09:28 AM

Seen: 3140 times

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