Home Forums SQL Server 2005 Administering Error: 602, Severity: 21, State: 30. RE: Error: 602, Severity: 21, State: 30.

  • May 11, 2009 at 3:35 pm

    #992507

    spellbound (5/9/2009)

    Hi,

    I am getting the following error on my SQL Server.

    Error: 602, Severity: 21, State: 30. Could not find an entry for table or index with partition ID in database 2. This error can occur if a stored procedure references a dropped table, or metadata is corrupted. Drop and re-create the stored procedure, or execute DBCC CHECKDB.

    Could you please provide a solution to overcome this error.

    I had run DBCC CHECKDB on tempdb database but found no errors.

    The SQL Server has the latest service pack.

    Regards,

    Spellbound

    As the message suggests if you did not find your tempdb corrupted, then is your code trying to refer to a temporary table the tempdb? Have you restarted the server? OR have u dropped any object that is refrrenced by your code?