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.