June 1, 2009 at 10:56 pm
I get this error message when I try to execute a stored procedure.
No catalog entry found for partition ID 8646911294669324288 in database 2. The metadata is inconsistent. Run DBCC CHECKDB to check for a metadata corruption.
If I run the SQL code inside the SPROC it works fine. I have tried recreating, renaming, different database, everything, always the same response (but different partition ID number).
DBCC CheckDB never shows any issues.
Please Help
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 12, 2009 at 11:14 pm
I got the same error message when i trying to select one table in the particular database.
August 14, 2009 at 11:08 am
I believe that 'Database 2' is tempdb.
Try stopping and restarting SQL Server.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
August 14, 2009 at 12:05 pm
See - http://www.sqlservercentral.com/Forums/Topic770808-149-1.aspx
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
April 26, 2013 at 8:37 am
On SQL 2005, you will be surprised that reindexing a temporary table can cause this error.
I have tested this on other versions like 2012 and it does not arise.
I guess something is causing some kinda data change on an object which is resident on TempDB while the data is being referenced by a transaction, hence the error.
May 24, 2013 at 12:01 pm
I was surprised when it happened to me, once I removed the index on temporary table that fixed it.
Good find and thanx
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply