May 31, 2011 at 10:02 am
SQL server 2005
version: 9.0.3077 (SP2 with KB960089)
The error in the system event log:
Event ID: 602.
Could not find an entry for table or index with partition ID 491897996509184 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
I have researched this event id, and found out a related article here:
http://support.microsoft.com/kb/937343
The solution, according to the article is:
Cumulative update information
To resolve this problem, obtain Cumulative Update 3 for SQL Server 2005 Service Pack 2 (build 3186). For more information about how to obtain Cumulative Update 3 for SQL Server 2005 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:
939537 (http://support.microsoft.com/kb/939537/ ) Cumulative update package 3 for SQL Server 2005 Service Pack 2
My question to you:
Should I apply the above update. When I read the article, it sounds like its more like a "hot fix". They say it has not been fully tested, etc.
Or should I just apply the latest Service Pack. I believe it's SP4?
What do you think?.
May 31, 2011 at 12:02 pm
have you run DBCC checkdb against your system databases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply