Maintenance Plan

I am running SQL 2005 SP2
Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
When I try to create a maintenance plan it says
TITLE: Microsoft SQL Server Management Studio
--
Method not found: 'Void
Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'.
(Microsoft.SqlServer.MaintenancePlanTasksUI)
BUTTONS:
OK
--
A search on the web didn't turn much up. One posting said there was a new
version of SP2 but I haven't found a newer one.
Any Ideas?
Thankssuper1,
I don't have this problem and I am currently at build 9.00.3159. If you go
to http://technet.microsoft.com/en-us/default.aspx and search "SQL Server
2005 SP2" "Critical Update" you will find some information on post-SP2
patches. (From reading this, perhaps I need to apply at least one more.)
RLF
"super1" <superbrownbrown1@.nospam.nospam> wrote in message
news:%234VBEHC4HHA.3400@.TK2MSFTNGP03.phx.gbl...
>I am running SQL 2005 SP2
> Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
> Feb 9 2007 22:47:07
> Copyright (c) 1988-2005 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
> When I try to create a maintenance plan it says
> TITLE: Microsoft SQL Server Management Studio
> --
> Method not found: 'Void
> Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'.
> (Microsoft.SqlServer.MaintenancePlanTasksUI)
> --
> BUTTONS:
> OK
> --
>
> A search on the web didn't turn much up. One posting said there was a new
> version of SP2 but I haven't found a newer one.
> Any Ideas?
> Thanks|||You need to apply a hotfix or the cumulative update:
http://support.microsoft.com/kb/933508
http://support.microsoft.com/kb/936305
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"super1" <superbrownbrown1@.nospam.nospam> wrote in message
news:%234VBEHC4HHA.3400@.TK2MSFTNGP03.phx.gbl...
>I am running SQL 2005 SP2
> Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
> Feb 9 2007 22:47:07
> Copyright (c) 1988-2005 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
> When I try to create a maintenance plan it says
> TITLE: Microsoft SQL Server Management Studio
> --
> Method not found: 'Void
> Microsoft.SqlServer.Management.DatabaseMaintenance.TaskUIUtils..ctor()'.
> (Microsoft.SqlServer.MaintenancePlanTasksUI)
> --
> BUTTONS:
> OK
> --
>
> A search on the web didn't turn much up. One posting said there was a new
> version of SP2 but I haven't found a newer one.
> Any Ideas?
> Thanks|||Thanks for the info. I have requested the patch.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%236oJBmC4HHA.2312@.TK2MSFTNGP06.phx.gbl...
> You need to apply a hotfix or the cumulative update:
> http://support.microsoft.com/kb/933508
> http://support.microsoft.com/kb/936305
>
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "super1" <superbrownbrown1@.nospam.nospam> wrote in message
> news:%234VBEHC4HHA.3400@.TK2MSFTNGP03.phx.gbl...
>|||Hi superbrown,
Did this issue persist after you installed the patch?
Normally this issue should not occur if SQL Server 2005 SP2 was
successfully installed. If this issue persists, I recommend that you check
if your SQL Server 2005 SP2 had been installed successfully. You can check
the setup logs (summary.txt etc) from this folder %ProgramFiles%\Microsoft
SQL Server\90\Setup Bootstrap\LOG\Hotfix.
If there is no error in the setup log, as a possible workaround, I
recommend that just uninstall SQL Server 2005 Client Tools, and then
reinstall it and SQL Server 2005 SP2 to see if this issue persists. To
uninstall SQL Server 2005 Client Tools, you can refer to the following
steps:
1. Open Control Panel -> Add or Remove Programs
2. Select Microsoft SQL Server 2005 from the list, click Remove, just
select Workstation Components from the "Remove SQL Server 2005 common
components" list, and click Next.
3. Follow the wizard to end the uninstallation.
Hope this helps. If this issue persists, I recommend that send the SP2
setup logs to me for further research. However the process may need your
sending me (changliw_at_microsoft_dot_com) an email response so that I can
create a workspace for your uploading the files.
If you have any other questions or concerns, please feel free to let me
know. It is my pleasure to be of assistance.
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||I applied this hotfix pack.
http://support.microsoft.com/kb/936305
And it didn't fix the problem. The log has an entry that says
Product : SQL Server Tools and Workstation Components 2005
Product Version (Previous): 1399
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance SQL Tools does not have
prerequisite update 3042 installed. Update 3175 is dependent on prerequisite
update 3042. Exit setup and refer to the Knowledge Base article to find the
prerequisite patch. Install the prerequisite and rerun the installation.
So I need another hotfix first?
This other hotfix was referenced by Andrew.
http://support.microsoft.com/kb/933508
I have requested it from Microsoft but they have not sent it to me yet.
"Charles Wang[MSFT]" <changliw@.online.microsoft.com> wrote in message
news:gDPvcGJ4HHA.4100@.TK2MSFTNGHUB02.phx.gbl...
> Hi superbrown,
> Did this issue persist after you installed the patch?
> Normally this issue should not occur if SQL Server 2005 SP2 was
> successfully installed. If this issue persists, I recommend that you check
> if your SQL Server 2005 SP2 had been installed successfully. You can check
> the setup logs (summary.txt etc) from this folder %ProgramFiles%\Microsoft
> SQL Server\90\Setup Bootstrap\LOG\Hotfix.
> If there is no error in the setup log, as a possible workaround, I
> recommend that just uninstall SQL Server 2005 Client Tools, and then
> reinstall it and SQL Server 2005 SP2 to see if this issue persists. To
> uninstall SQL Server 2005 Client Tools, you can refer to the following
> steps:
> 1. Open Control Panel -> Add or Remove Programs
> 2. Select Microsoft SQL Server 2005 from the list, click Remove, just
> select Workstation Components from the "Remove SQL Server 2005 common
> components" list, and click Next.
> 3. Follow the wizard to end the uninstallation.
> Hope this helps. If this issue persists, I recommend that send the SP2
> setup logs to me for further research. However the process may need your
> sending me (changliw_at_microsoft_dot_com) an email response so that I can
> create a workspace for your uploading the files.
> If you have any other questions or concerns, please feel free to let me
> know. It is my pleasure to be of assistance.
> Best regards,
> Charles Wang
> Microsoft Online Community Support
> ========================================
=============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ========================================
==============
>|||I removed the management tools, re-applied SP2 and added the tools back in.
Now I can create a Maintenance Plan.
Thanks, Hopefully the rest goes well.
"super1" <superbrownbrown1@.nospam.nospam> wrote in message
news:%23vXvzfO4HHA.2208@.TK2MSFTNGP06.phx.gbl...
>I applied this hotfix pack.
> http://support.microsoft.com/kb/936305
> And it didn't fix the problem. The log has an entry that says
> Product : SQL Server Tools and Workstation Components
> 2005
> Product Version (Previous): 1399
> Product Version (Final) :
> Status : NA
> Log File :
> Error Description : The product instance SQL Tools does not have
> prerequisite update 3042 installed. Update 3175 is dependent on
> prerequisite update 3042. Exit setup and refer to the Knowledge Base
> article to find the prerequisite patch. Install the prerequisite and rerun
> the installation.
> So I need another hotfix first?
> This other hotfix was referenced by Andrew.
> http://support.microsoft.com/kb/933508
> I have requested it from Microsoft but they have not sent it to me yet.
>
> "Charles Wang[MSFT]" <changliw@.online.microsoft.com> wrote in message
> news:gDPvcGJ4HHA.4100@.TK2MSFTNGHUB02.phx.gbl...
>