InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 06:34:53 GMT20http://www.sqlservercentral.com/Forums/Topic1377390-1549-1.aspxorigininal error message after running [b]exec [sp_ShowContigAll] 0,1,95[/b] was"Msg 2588, Sev 16, State 3, Line 1 : Cannot find partition number 1 for index ID 19, object ID 803586001. [SQLSTATE 42000]"I ran dbcc checkdb and check alloc and both returned no errors, the db is perfectly normal. But I also found my own answer too.Some other admin had started "Database Engine Tuning Advisor" and the process died unexpectedly and all the Hypothetical Indexes and Statisticswere not cleared. The index pointed in the error message is one of those, so I cleared all of those with this script and reindexed the db with no problem. I hope it helps some others.select 'drop index ' + b.name + '.' + a.name from sys.indexes a, sys.all_objects b where a.object_id = b.object_id and is_hypothetical = 1[url=http://msdn.microsoft.com/en-us/library/ms190172(v=sql.105).aspx][/url]Sat, 16 Feb 2013 13:21:25 GMTfullname-214799http://www.sqlservercentral.com/Forums/Topic1377390-1549-1.aspxRun the following, post the full, complete and unedited output[code]DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS[/code]Sat, 16 Feb 2013 03:32:32 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1377390-1549-1.aspx[quote][b]opc.three (11/9/2012)[/b][hr]I have not seen that error before, but it does not sound good. Have you run DBCC CHECKDB(your_dbname) WITH NO_INFOMSGS on your database lately? If you run it and it returns errors post the complete output here.[/quote]Hi,I have the same problem like RK2012. Ran dbcc as you said and it returned no errors. What shpuld I do next. Also RK2012 did you find a solution that you can post here. Thanks in advance,Sat, 16 Feb 2013 02:35:47 GMTfullname-214799http://www.sqlservercentral.com/Forums/Topic1377390-1549-1.aspxI have not seen that error before, but it does not sound good. Have you run DBCC CHECKDB(your_dbname) WITH NO_INFOMSGS on your database lately? If you run it and it returns errors post the complete output here.Fri, 09 Nov 2012 22:23:25 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1377390-1549-1.aspxHello,My job got failed due to below errorCannot find partition number 1 for index ID 30, object ID 437576597. [SQLSTATE 42000] (Error 2588) DBCC execution completedKindly help me on this.Thu, 25 Oct 2012 22:40:44 GMTRK2012