SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


I can't get Modify (Maintenance Plans) to do anything.


I can't get Modify (Maintenance Plans) to do anything.

Author
Message
dflbob
dflbob
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 37
In SSMS, when I highlight a maintenance plan that I successfully created, right click, and then select Modify, nothing happens. I was under the impression that a window would open for me to then review the plan and modify, as needed.

The problem is the same on two systems I've set up: one running SQL Server 2008, tho other 2008 R2.
Markus
Markus
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3941 Visits: 3798
Yes, it should.

Are you doing this from Mgt Studio on your PC, or on the physical Server? Which ever one you are trying to do this on go to the opposite and try it there. Can you try this on any other PC/Server running Mgt Studio 2008?



dflbob
dflbob
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 37
The two systems are in different locations. I could, though, set up SSMS on my desktop here in my office to test this. As I recall, the installation of SSMS is part of the SQL Server installation (or is that incorrect?). If true, is there a way to install just SSMS? Or is there a separate download available for it?
Scott D. Jacobson
Scott D. Jacobson
Right there with Babe
Right there with Babe (764 reputation)Right there with Babe (764 reputation)Right there with Babe (764 reputation)Right there with Babe (764 reputation)Right there with Babe (764 reputation)Right there with Babe (764 reputation)Right there with Babe (764 reputation)Right there with Babe (764 reputation)

Group: General Forum Members
Points: 764 Visits: 1018
You run the same installer but only choose the Management Tools when prompted for which components to install. No database engine, no Integration Services etc. etc.

If you don't have the install media handy, I believe you can use the evaluation installer from MS. If you're only installing SSMS, I don't believe the evaluation period applies. Someone may want to correct me if I'm wrong about this part.
Markus
Markus
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3941 Visits: 3798
If you are in one location and attempting to open a Maint plan at a different location it might be slow based on your connection speed between the two locations.

As far as the tools... It all depends on if whomever installed SQL Server if they installed the Management tools on the server.

As far as installing Management Studio on your PC yes you can. You would simply used the same DVD/CD install for SQL Server and only pick the Management Tools when it comes time to pick what you want to install.



derek 2364
derek 2364
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 2
It appears the problem still exists today with SQL Server 2014. When you install SQL Server, you need to check both the boxes under Management Tools. One is called "Basic." I can't remember what the second option is for, but if you just select the basic option, you'll get SSMS Express!
Hopefully this will help some folks out there struggling with this.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search