March 18, 2008 at 9:58 am
I just applied SP2 to our SQL2005 cluster environment. When I try to schedule a maintenance plan it produces:
"Unhandled exception has occurred in a component in your application" message. It follows by:
"Method not found: 'Boolean Microsoft.SqlServer.Management.SqlMgmt.JobScheduleData.UpdateSourceSchedule()'
Does anybody have an idea what's going on? I tried to Google - could not find the solution yet.
Thanks a lot in advance
March 18, 2008 at 10:59 am
I had the same issue. I had to uninstall SQL Server 2005 instance, restarted the server and reapplied SP2. Mine was active/passive cluster. Worst thing I found about the SP2 is that you cannot uninstall it like other service packs for 2000. Its such a pain in the b***.
http://www.mssqltips.com/tip.asp?tip=1186
SQL DBA.
March 18, 2008 at 11:00 am
there is high possibility that either
1. server and client are not on same service pack level
OR
2. we did ignore some error during service pack OR RTM setup
if you can share your file with me, i can have a look
send me email at bmlakhani@yahoo.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply