Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

How to correct error in Sql Server: An inconsistency was detected during an internal operation in database 'Nawada'(ID:6) on page (1:14194556). Please contact technical support. Reference number 4.

Avatar of searchsanjaysharma
searchsanjaysharma asked on
Microsoft SQL Server 2005
10 Comments1 Solution1579 ViewsLast Modified:
I have a database Nawada, and Table name is txndependents
for which i am not able to fetch record because of above error.
The output of dbcc checkdb is as follows: This has stuck my work, Please help, so that i can correct the error.

DBCC results for 'TxnDependents'.
Msg 8928, Level 16, State 1, Line 1
Object ID 1093578934, index ID 1, partition ID 72057594040614912, alloc unit ID 72057594045071360 (type In-row data): Page (1:14194556) could not be processed.  See other errors for details.
Msg 8944, Level 16, State 18, Line 1
Table error: Object ID 1093578934, index ID 1, partition ID 72057594040614912, alloc unit ID 72057594045071360 (type In-row data), page (1:14194556), row 0. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 25 and 67.
Msg 8944, Level 16, State 18, Line 1
Table error: Object ID 1093578934, index ID 1, partition ID 72057594040614912, alloc unit ID 72057594045071360 (type In-row data), page (1:14194556), row 0. Test (columnOffsets->offTbl [varColumnNumber] >= priorOffset) failed. Values are 25 and 67.
There are 24621219 rows in 320099 pages for object "TxnDependents".
CHECKDB found 0 allocation errors and 3 consistency errors in table 'TxnDependents' (object ID 1093578934).