Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-14 : 08:34:01
|
manish writes "when i run checkalloc after checkdb, it shows error allocation discrepancy objectname 87902729 something....
but when i check that object name in sysobjects, that table does not exist .select object_name('......) -> null
why this is showing discrepancy in nonexistence table.
is there any significance for this no-existed table.
pls help
manish" |
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-02-14 : 23:47:16
|
Please post the complete output from
DBCC CHECKDB (dbname) WITH NO_INFOMSGS, ALL_ERRORMSGS
Is it possible the table was deleted since/during the DBCC run?
Paul Randal
Principal Lead Program Manager, Microsoft SQL Server Core Storage Engine
(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.)
http://blogs.msdn.com/sqlserverstorageengine/default.aspx |
 |
|
|
|
|
|
object_name is null