Sunday, February 26, 2012

Error:602,Severity:21,State:4

Hi,


In my application i used to do the take the backup of current

database and restore it with a backup which was taken earlier and

execute a select command on a particular table.

My problem is,backup & restore operations get completed

successfully but error is raised when tried to open a recordset

for a select statement.Following error was recorded in the sql

error log.

Error: 602, Severity: 21, State: 4

Could not find row in sysindexes for database ID 15, object ID

1109578991, index ID 1. Run DBCC CHECKTABLE on sysindexes..

After this i terminated my application and repeated the above

operation this time i got the same error but with index ID 0 but

the database id and object id remained the same.

When scanned the sysobjects for the particular objectid and i

found out that the id belong to a SP - dt_setpropertybyid_u


I have encountered the same problem three times,but after that i

did not get the problem

Regards

I would suggest running a CHECKDB on the database. If the database is too large find out which tables the query touches and run a CHECKTABLE on the those tables.

The following article could be helpful:

http://msdn2.microsoft.com/en-us/library/aa258727(SQL.80).aspx

http://msdn2.microsoft.com/en-us/library/aa258762(sql.80).aspx

HTH

No comments:

Post a Comment