July 31, 2002 at 12:03 pm
Hello everyone,
I have a few object IDs and want to know which database these objects belong to. How can I find this info?
Thanks all.
July 31, 2002 at 1:28 pm
search sysobjects in each database.
Steve Jones
July 31, 2002 at 2:01 pm
This solution doesn't work for me. I have got the following error:
"Table Corrupt: IAM page (1:356204) (object ID 1458104235, index ID 0) is out of the range of this database."
But this Object ID can exist in multiple databases. What does the 1:356204 stand for? Is there a way to trace this error to the database that it occured in? Thanks.
July 31, 2002 at 3:24 pm
This is a page id from the pages stored in the db. You can get the objectid from each database and query each table (Select *). One should give you an error.
Steve Jones
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply