SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 object_name is null
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 02/14/2007 :  08:34:01  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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

USA
899 Posts

Posted - 02/14/2007 :  23:47:16  Show Profile  Visit paulrandal's Homepage  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000