Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqltech2010
Starting Member
1 Post |
 Posted - 2011-05-31 : 12:05:49
|
| SQL server 2005version: 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/937343The solution, according to the article is:Cumulative update informationTo 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?. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-31 : 12:57:52
|
| Sounds like you need the hotfix so either go for sp4 or the hotfix.Either way is a risk that it will have side effects - you need to go through the normal testing you carry out for a service pack so I would go for sp4. sp2 is a bit old.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SQL 2005 SP2 undexpectedly shuts down