October 28, 2005 at 9:49 am
Hi everyone, I was reading through what BOL says about this error and I had a question about this part:
If instead of an object name the error displays a number greater than 0, it means that an attempt was made to reference an object ID that does not exist in a system table for that object.
Does this mean an object such as a temporary object that was created through our code and then dropped later in the code? What kind of object are they talking about? We are getting this error very frequently in the past couple of weeks and the error is always showing an object ID instead of a name and that is why I am curious to know what the object can be. The 605 error text I get is:
Msg 605, Sev 21: Attempt to fetch logical page (1:18506) in database 'proddb' belongs to object '1852795252', not to object 'proddb_table1'. [SQLSTATE HY000]
Thanks.
October 28, 2005 at 10:07 am
looks you have some database corruption
October 28, 2005 at 10:19 am
Yes, unfortunately that is the case and has happened 4 times in the past 2 weeks. The thing is that the second object in the error is always presented as a number. So I was wondering what the BOL part about the object ID means. Thanks.
October 28, 2005 at 10:48 am
try
USE mytargetdatabase
SELECT TABLE_CATALOG, TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME = OBJECT_NAME(1852795252)
October 28, 2005 at 10:56 am
Thanks for yoru help. I tried that and object_name(1852795252) and it doesn't return anything. That's why I think that perhapse it is a table that created by one of our scripts and then later dropped? That's why I am trying to figure out what the BOL segment that I posted means. :o(
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply