Click here to monitor SSC
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
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 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
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1864 Visits: 3736
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
Grasshopper
Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)Grasshopper (18 reputation)

Group: General Forum Members
Points: 18 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
SSC-Addicted
SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)SSC-Addicted (459 reputation)

Group: General Forum Members
Points: 459 Visits: 1006
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
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1864 Visits: 3736
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.



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