The result of DBCC PAGE provides lots of information, however, we should specifically look at PAGE HEADER section for “Metadata: ObjectId “. It would provide us the ObjectId. Once we have the object_id, it is an easy to get the object name as below. Please note, we should select the database name while executing the command otherwise, we might end up no result or wrong information.
DBCC TRACEON (3604); DBCC PAGE (9, 1, 401776, 0); DBCC TRACEOFF (3604);
I’d like to grow my readership. If you enjoyed this blog post, please share it with your friends!
Select db_name(9) GO use <dbname_from_previous_query> GO Select object_name(946818435)