InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 01:39:44 GMT20http://www.sqlservercentral.com/Forums/Topic1357850-266-1.aspxNot repairable. There's damage to the system tables.Script all objects, export all data and recreate the database. Then set up a backup strategy.Fri, 14 Sep 2012 02:37:24 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1357850-266-1.aspxHi, This is complete error:" Msg 8952, Level 16, State 1, Line 1Table 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 1Index 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 1Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:Msg 8955, Level 16, State 1, Line 1Data 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 1Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:Msg 8955, Level 16, State 1, Line 1Data 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 1Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:Msg 8955, Level 16, State 1, Line 1Data 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).Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Order_Convert_Price'. The column ID 18 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Sr_No'. The column ID 19 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Location_ID'. The column ID 2 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Stock_ID'. The column ID 3 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'UM_ID'. The column ID 4 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Invoice_Quantity'. The column ID 5 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Selling_Price'. The column ID 6 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Convert_Price'. The column ID 7 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Stocking_Quantity'. The column ID 8 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Invoice_Date'. The column ID 9 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Order_ID'. The column ID 10 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Delivering_Qty'. The column ID 11 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Delivering_S_Qty'. The column ID 12 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Stocking_Price'. The column ID 13 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Expired_Date'. The column ID 14 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Item_Discount'. The column ID 15 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Serial_No'. The column ID 16 is not valid for this table. The valid range is from 1 to 1.Msg 8932, Level 16, State 2, Line 1Table error: Object ID 1652942452, index ID 0, column 'Brand_ID'. The column ID 17 is not valid for this table. The valid range is from 1 to 1.CHECKDB found 0 allocation errors and 18 consistency errors in table 'NSS35427410' (object ID 1652942452).CHECKDB found 0 allocation errors and 22 consistency errors in database 'FOR11213'. "I have no clean backup. I can run 'SELECT * FORM NSD34949300' but I can't drop that table. There is no data in this table. Now, When I run 'Drop Table NSD34949300',error appear that:'Msg 3701, Level 11, State 5, Line 1Cannot drop the table 'NSD34949300', because it does not exist in the system catalog.'Thanks and best regards.NayMinnThu, 13 Sep 2012 21:46:52 GMTnayminnaghttp://www.sqlservercentral.com/Forums/Topic1357850-266-1.aspxI 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 CheckDBNow, 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?Thu, 13 Sep 2012 01:17:22 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1357850-266-1.aspxThanks 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 1Table 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 1Index 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 1Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:Msg 8955, Level 16, State 1, Line 1Data 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 1Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:Msg 8955, Level 16, State 1, Line 1Data 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 1Table error: Table 'syscolumns' (ID 3). Missing or invalid key in index 'ncsyscolumns' (ID 2) for the row:Msg 8955, Level 16, State 1, Line 1Data 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 regardsNayMinWed, 12 Sep 2012 22:02:49 GMTnayminnaghttp://www.sqlservercentral.com/Forums/Topic1357850-266-1.aspxPlease run the following and post the full and complete output.[code]DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS[/code]Without knowing the extent of the errors, no sensible solution can be suggested.Wed, 12 Sep 2012 07:52:33 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1357850-266-1.aspxThis is a nonclustered index. You can drop the index first.Hope you have good backup, in case required.Wed, 12 Sep 2012 04:58:18 GMTSuresh B.http://www.sqlservercentral.com/Forums/Topic1357850-266-1.aspxBefore applying any solution first run a DBCC CHECKDB command. Check is it reported any error message or not?Wed, 12 Sep 2012 04:22:16 GMTprettsonshttp://www.sqlservercentral.com/Forums/Topic1357850-266-1.aspxDear 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 MinWed, 12 Sep 2012 03:13:44 GMTnayminnag