March 5, 2009 at 9:42 pm
I get this when I run DBCC CHECKCATALOG:
Check Catalog Msg 3853, State 1:
Attribute (default_object_id=50331648) of row (object_id=68,column_id=17)
in sys.columns does not have a matching row (object_id=50331648) in sys.objects.
The error is that the default_object_id of sysxmitqueue.hdrseclen, it should have no default object but it's set to an object which doesn't exist.
DBCC CHECKDB can't be used to fix catalog errors, and a directly manipulation of system tables is not allowed.
What can I do to fix this problem?
March 6, 2009 at 3:01 am
Take a look at this article. There's a section on these catalog errors. http://www.sqlservercentral.com/articles/65804/
Bad news, the fix is not easy.
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply