September 16, 2008 at 3:11 pm
I'm new to SQLServer environment. I was given a task to review the maintenance plan on sqlserver 2005 production server that was already set by someone else. When I right click on the maint plan, I selected "modified". It gave me a mesage:
"This maintenance plan has been modified using a tool other than the maintenance plan designer. You must use SQL Server Integration Services to modify this maintenance plan from now on.(Object Explorer)"
I researched on google and it said that it said to upgrade my tool to sp2. I checked my sqlserver2005 tool on my workstation and my sp version is 4 of the standard edition and the production environment has enterprise edition of sp2. I have no problem of doing the same thing on another production environment. I'm not sure why I received this message and sure do not want to sue SQL Server Integration Services.
How can I fix in order for me to view the maint plan.
Thank you in advance for your help.
September 17, 2008 at 2:49 am
Hi,
There is no SP4 for SS2K5 (nor yet SP3). How did you check the version of your workstation tools? Sounds like they do need upgrading to SP2.
Cath
September 17, 2008 at 12:38 pm
I ran the query command
select @@version
and the result
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
sorry, I looked at the wrong thing. When I looked at 9.00.1399.06, how do I know what service pack of this version is?
September 17, 2008 at 1:28 pm
What you did was show the version of SQL Server that you were connected to. To see the version for your client tools - click on Help | About.
Version 9.0.1399 is RTM, 9.0.3042 and greater is SP2. I would recommend upgrading to the at least 9.0.3054 and even higher if possible.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 17, 2008 at 1:50 pm
Thanks Jeffrey. One last question. I never upgrade before so where can I get the instruction to upgrade to upgrade from 9.0.1399 to 9.0.3054.
September 17, 2008 at 2:09 pm
Version 9.0.3054 is service pack two with a small patch to fix some problems with maintenance plans. You can find more information at:
http://support.microsoft.com/kb/934458
This contains a link to the update which will be applied after upgrading to service pack 2. If possible, you really should look to upgrade to the latest cumulative update (search microsoft for the latest available).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
September 17, 2008 at 2:37 pm
Thanks Jeffrey. I will look into it. :hehe:
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply