How can i drop table?

Question

Post reply

How can i drop table?

nayminnag

SSC Rookie

Points: 37
More actions
September 12, 2012 at 3:13 am

#261432

Dear all,
I have an error in my database. I write command that is
'Drop table tb_name'.
When i run that command, I got the error that is:
'Could not find the index entry for RID '1674e85621000300' in index page (1:182), index ID 2, database 'db_name''
So, may i know how can i drop this table.
Thanks for All,
Nay Min
September 12, 2012 at 4:22 am

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Suresh B. SSC-Insane Points: 22986 More actions · Answer 1

This is a nonclustered index. You can drop the index first.

Hope you have good backup, in case required.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Please run the following and post the full and complete output.

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS

Without knowing the extent of the errors, no sensible solution can be suggested.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

nayminnag SSC Rookie Points: 37 More actions · Answer 3

Thanks for your reply:

When checking Database with

DBCC CHECKDB()......

I got many error lines. First few lines are:

"Msg 8952, Level 16, State 1, Line 1

Table error: Database 'FOR11213', index 'sysobjects.ncsysobjects' (ID 1) (index ID 2). Extra or invalid key for the keys:

Msg 8956, Level 16, State 1, Line 1

Index row (1:186:32) with values (name = 'NSD34949300' and uid = 1 and id = 1652942452) points to the data row identified by ().

CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysobjects' (object ID 1).

Msg 8951, Level 16, State 1, Line 1

Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:

Msg 8955, Level 16, State 1, Line 1

Data row (1:28568:0) identified by (RID = (1:28568:0) id = 1652942452 and colid = 17 and number = 0) has index values (id = 1652942452 and name = 'Brand_ID' and number = 0 and id = 1652942452 and colid = 17 and number = 0).

Msg 8951, Level 16, State 1, Line 1

Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:

Msg 8955, Level 16, State 1, Line 1

Data row (1:28568:1) identified by (RID = (1:28568:1) id = 1652942452 and colid = 18 and number = 0) has index values (id = 1652942452 and name = 'Order_Convert_Price' and number = 0 and id = 1652942452 and colid = 18 and number = 0).

Msg 8951, Level 16, State 1, Line 1

Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:

Msg 8955, Level 16, State 1, Line 1

Data row (1:28568:2) identified by (RID = (1:28568:2) id = 1652942452 and colid = 19 and number = 0) has index values (id = 1652942452 and name = 'Sr_No' and number = 0 and id = 1652942452 and colid = 19 and number = 0).

CHECKDB found 0 allocation errors and 3 consistency errors in table 'syscolumns' (object ID 3)."

Thanks and bet regards

NayMin

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

I asked for the full and complete output. I asked for that for a reason, one cannot make sensible recommendations about fixing a DB from partial output from CheckDB

Now, please post the full and complete, unedited output. Either in the text of the post or attach it as a text file attachment.

Do you have a clean backup? One without the corruption?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

nayminnag SSC Rookie Points: 37 More actions · Answer 5

Hi, This is complete error:

" Msg 8952, Level 16, State 1, Line 1

Table error: Database 'FOR11213', index 'sysobjects.ncsysobjects' (ID 1) (index ID 2). Extra or invalid key for the keys:

Msg 8956, Level 16, State 1, Line 1

Index row (1:186:32) with values (name = 'NSD34949300' and uid = 1 and id = 1652942452) points to the data row identified by ().

CHECKDB found 0 allocation errors and 1 consistency errors in table 'sysobjects' (object ID 1).

Msg 8951, Level 16, State 1, Line 1

Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:

Msg 8955, Level 16, State 1, Line 1

Data row (1:4312:0) identified by (RID = (1:4312:0) id = 1652942452 and colid = 17 and number = 0) has index values (id = 1652942452 and name = 'Brand_ID' and number = 0 and id = 1652942452 and colid = 17 and number = 0).

Msg 8951, Level 16, State 1, Line 1

Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:

Msg 8955, Level 16, State 1, Line 1

Data row (1:4312:1) identified by (RID = (1:4312:1) id = 1652942452 and colid = 18 and number = 0) has index values (id = 1652942452 and name = 'Order_Convert_Price' and number = 0 and id = 1652942452 and colid = 18 and number = 0).

Msg 8951, Level 16, State 1, Line 1

Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:

Msg 8955, Level 16, State 1, Line 1

Data row (1:4312:2) identified by (RID = (1:4312:2) id = 1652942452 and colid = 19 and number = 0) has index values (id = 1652942452 and name = 'Sr_No' and number = 0 and id = 1652942452 and colid = 19 and number = 0).

CHECKDB found 0 allocation errors and 3 consistency errors in table 'syscolumns' (object ID 3).