Sunday, February 19, 2012

DBCC CHECKDB returns error, sys.sysobjvalues

Hello,
Just starting to work with sql 2005.
Run DBCC CHECKDB on user database and received this message:
Incorrect PFS free space information for page (1:224) in object ID 60, index
ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type LOB
data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
CHECKDB found 0 allocation errors and 2 consistency errors in table
'sys.sysobjvalues' (object ID 60).
The thing is I can't find sys.sysobjvalues table anywhere.
What is it?
Thanks.
Hi Jan
If you run sp_help, or select * from sys.objects, you should see object, and
see the fact that it is a system table.
By default, you cannot access the system tables in SQL Server 2005; metadata
is accessed through catalog views (such as sys.objects)
If you use the Dedicated Administrator Connection, you can select from
sys.sysobjvalues, but it wouldn't enlighten you much as it is very cryptic
information.
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Jan" <Jan@.discussions.microsoft.com> wrote in message
news:79ED5E8D-0BAC-4E1B-8109-A8659F78513C@.microsoft.com...
> Hello,
> Just starting to work with sql 2005.
> Run DBCC CHECKDB on user database and received this message:
> Incorrect PFS free space information for page (1:224) in object ID 60,
> index
> ID 1, partition ID 281474980642816, alloc unit ID 71776119065149440 (type
> LOB
> data). Expected value 0_PCT_FULL, actual value 100_PCT_FULL.
> CHECKDB found 0 allocation errors and 2 consistency errors in table
> 'sys.sysobjvalues' (object ID 60).
> The thing is I can't find sys.sysobjvalues table anywhere.
> What is it?
> Thanks.

No comments:

Post a Comment