|
Home > Archive > MS SQL Server > October 2006 > DBCC CHECKDB returns error, sys.sysobjvalues
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
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.
| |
| Kalen Delaney 2006-10-24, 6:33 pm |
| 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@microso
ft.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.
|
|
|
|
|