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 |
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
 Posted - 2007-08-01 : 06:46:49
|
| [code]The In-row data RSVD page count for object "PermitSlots", index ID 0, partition ID 31139347693568, alloc unit ID 31139347693568 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE[/code]Hi, I received the following message after a DBCC run. This was fixed by a DBCC UpdateUsage. The question is, is there a reference where I can find details on errors as the above and their causes (other than Googling it or posting to a forum)?ThanksDrew---------------------"It's Saturday night; I've got no date, a two litre bottle of Shasta, and my all-Rush mix tape... LET'S ROCK." |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-01 : 11:28:58
|
| Can try books online. |
 |
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2007-08-01 : 11:34:23
|
| It doesn't appear to hold info such errors.Drew---------------------"It's Saturday night; I've got no date, a two litre bottle of Shasta, and my all-Rush mix tape... LET'S ROCK." |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-01 : 12:00:23
|
| You can search knowledge base in books online. |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2007-08-01 : 13:00:46
|
quote:
Originally posted by drewsalem
It doesn't appear to hold info such errors.Drew---------------------"It's Saturday night; I've got no date, a two litre bottle of Shasta, and my all-Rush mix tape... LET'S ROCK."
The Books Online for CHECKDB has info on why this can happen, as does the Readme when you install SQL Server 2005.In earlier versions of SQL Server, the values for the per-table and per-index row count and page counts can become incorrect. Under certain circumstances, one or more of these values might even become negative. DBCC CHECKDB does not detect this issue. This is not a corruption of any data stored in the database, and the situation is typically addressed by running the DBCC UPDATEUSAGE command. In SQL Server 2005, DBCC CHECKDB has been enhanced to detect when any one of these counts becomes negative. When detected, the DBCC CHECKDB output contains a warning and a recommendation to run DBCC UPDATEUSAGE to address the issue. Although it may appear as if upgrading the database to SQL Server 2005 has caused this issue, it was, in fact, present before the upgrade procedure.Paul RandalPrincipal 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 |
|
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2007-08-02 : 04:24:54
|
Back already? Stumbled across a pic of you and the Mrs lookin very happy and sloshed :) Congrats.The Books Online for CHECKDB has info on why this can happen, as does the Readme when you install SQL Server 2005. Performing a keyword search on "The In-row data RSVD page"... returns nothing. How do I bring up what you quoted?Drew---------------------"It's Saturday night; I've got no date, a two litre bottle of Shasta, and my all-Rush mix tape... LET'S ROCK." |
|
|
|
drewsalem
Constraint Violating Yak Guru
304 Posts |
Posted - 2007-08-02 : 04:31:19
|
| Oh I found it. It would be handy though to have a dictionary of what all SQL Server error messages mean and to be able to just look it up in the one place, instead of digging around. Error message on left, meaning on right.Drew---------------------"It's Saturday night; I've got no date, a two litre bottle of Shasta, and my all-Rush mix tape... LET'S ROCK." |
|
|
|
|
|
|
|
|
Is there an error message library?