October 8, 2003 at 4:01 pm
A DBCC recently gave me messages like:
Msg 8929, Level 16, State 1, Line 1
Object ID <somenumber>: Errors found in text ID <somenumber> owned by data record identified by RID = (1:217610:20)
Is there a way to translate this (fileid:objectid:rid) format to the actual row in the table, so that I could look at the data?
Thanks!
October 9, 2003 at 5:34 am
A RID is the following
Row identifier of the locked row within the table. The row is identified by a fileid:page:rid combination, where rid is the row identifier on the page.
1 is your fileid
217610 is the page it is on
20 is the slot on that page
you can try the following to see the data
DBCC TRACEON (3604) -- This sends the output to the screen
GO
SELECT DB_ID('yourdbname') -- you will need this.
GO
DBCC PAGE (db_id_here, fileid_here, page_here, print_option) -- Use 3 as print_option as it will give column names when is a table page.
Unfortunately this will not tell you the table it was on unless you know your data but
Object ID <somenumber>:
will, do
SELECT OBJECT_NAME(<somenumber>)
and it will return the table name.
Hoepfully this will help you find the row that is your issue.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply