May 8, 2013 at 6:18 am
Hi all,
I am using a Test and production envoironment - both were 2005 -
I have created several Maintenance Plans in the past - I now want to modify one of them .....
So a simple right click on the selected plan and ..... nothing ... ziltch ...
I can Execute and view history ... but not modify - it does appear in the list in a BOLD FONT.
I have now tested this issue on the Test Server that is running SQL 2008 R2 -
Modify is still in bold - but it does allow me to modify !?
Is there a permissions or "Microsoft Feature" issue here ?
Any help would be appreciated.
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
May 8, 2013 at 12:21 pm
What is the version of the 2005 system? If is prior to SP2 with a hotfix you will have issues...
You also need to know what version of the client tools you are using. If you are trying to use the 2012 client tools to modify earlier version that will also cause problems.
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
May 8, 2013 at 12:50 pm
Hi,
It is SQL2005 SP2 ( without Hotfix! )
I have been reading that there is a problem reported from a windows update - I know that I was able to do modifications to MPs at some stage - as I set them up and recreated them a couple of years ago.
After that said, I am planning on doing an upgrade to SQL 2008 R2 (SP1 ) next week - which should resolve the issue -
Thanks
________________________________________________________________________________________________
Regards
Steve
SQL 2008 DBA/DBD - MCTS/MCITP
Please don't trust me, test the solutions I give you before using them.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply