ToolBox missing for Maintenance task

Question

ToolBox missing for Maintenance task

sqlfriend

SSC Guru

Points: 52781
More actions
January 17, 2017 at 11:12 am
Go to Answer
#401407

This morning I logged into SSMS SQL2016 to edit a maintenance plan. I would add a cleanup task.
But I noticed the toolbox for maintenance plan is empty.
I tried to reset windows , reset tool box, no luck. Still empty.
Help please.
Thanks
Anne
Lowell

SSC Guru

Points: 323518
More actions
January 17, 2017 at 1:26 pm
Answer
#1923267

you can end up getting the empty "toolbox" from visual studio, which IS NOT THE SAME as the ssis toolbox.
there's always a shortcut for the SSIS toolbox and SSIS variables in the upper right corner show here:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply

Kevin3NF SSCarpal Tunnel Points: 4765 More actions · Answer 1

sqlfriends - Tuesday, January 17, 2017 11:12 AM
This morning I logged into SSMS SQL2016 to edit a maintenance plan. I would add a cleanup task.
But I noticed the toolbox for maintenance plan is empty.
I tried to reset windows , reset tool box, no luck. Still empty.
Help please.
Thanks
Anne

What version of SSMS, and did you try Ctrl-Alt-X? Second person today to post this question...

------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NF DallasDBAs.com/Blog Why is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]

sqlfriend SSC Guru Points: 52781 More actions · Answer 2

sqlfriend

SSC Guru

Points: 52781

January 17, 2017 at 1:37 pm

#1923270

Lowell - Tuesday, January 17, 2017 1:26 PM

sqlfriend SSC Guru Points: 52781 More actions · Answer 3

sqlfriends - Tuesday, January 17, 2017 1:37 PM
Lowell - Tuesday, January 17, 2017 1:26 PM
you can end up getting the empty "toolbox" from visual studio, which IS NOT THE SAME as the ssis toolbox.
there's always a shortcut for the SSIS toolbox and SSIS variables in the upper right corner show here:

My SQL server is 2016. the SSMS tool is also SQL2016 version number 13.0.16100.1
here is a screen shot of the toolbox, it is empty, I right click the maintainance plan and edit, cannot see the toolbox.

sqlfriend SSC Guru Points: 52781 More actions · Answer 4

I resolved by adding the items back to the toolbox.
It is strange the default reset is to unselect all the items in the toolbox.

vladimir.muzny SSC Rookie Points: 45 More actions · Answer 5

Hi all,
seems so strange but I had the same issue with empty toolbox in Management Studio. It occured when I created first Maint. plan by wizzard and then went to edit it. I tried to create one maint. plan manually, and from the moment everything works fine for me.

Regards,
Vladimir

gerald72 SSC Enthusiast Points: 191 More actions · Answer 6

Hi,
I would recommend to stop using out-of-the-box maintenance tasks anyway. Deploying and monitoring on a higher number of sql instances is no fun at all. Just write your own procedures or use the procedures from ola hallengren to do the maintenance work. Also you are flexible with scheduling - you still can use sql agent or job schedulers like Control-M or UC4.

BR
Gerald

jmilano SSC Journeyman Points: 75 More actions · Answer 7

For those still looking for the correct solution. SSMS 2016 Toolbox empty.
In the Menu click "Tools", click "Choose Toolbox Items"
PS. I know nothing about SQL

Andre 425568 SSCrazy Points: 2479 More actions · Answer 8

sqlfriends - Tuesday, January 17, 2017 4:46 PM
I resolved by adding the items back to the toolbox.
It is strange the default reset is to unselect all the items in the toolbox.

How do you add the items back?

Andre 425568 SSCrazy Points: 2479 More actions · Answer 9

jmilano - Monday, October 2, 2017 1:53 PM
For those still looking for the correct solution. SSMS 2016 Toolbox empty.
In the Menu click "Tools", click "Choose Toolbox Items"
PS. I know nothing about SQL

Choose Toolbox Items is greyed out

Lowell SSC Guru Points: 323518 More actions · Answer 10

Lowell - Tuesday, January 17, 2017 1:26 PM
Toolbox is always empty. its the toolbox for Visual Studio .Net Forms, and NOT SSIS

you can end up getting the empty "toolbox" from visual studio, which IS NOT THE SAME as the SSIStoolbox.
there's always a shortcut for the SSIS toolbox and SSIS variables in the upper right corner show here:

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

datwungai SSChasing Mays Points: 648 More actions · Answer 11

gerald72 - Monday, September 25, 2017 10:24 AM
Hi,
I would recommend to stop using out-of-the-box maintenance tasks anyway. Deploying and monitoring on a higher number of sql instances is no fun at all. Just write your own procedures or use the procedures from ola hallengren to do the maintenance work. Also you are flexible with scheduling - you still can use sql agent or job schedulers like Control-M or UC4.
BR
Gerald

I'm also having this issue; just trying to create a simple maintenance plan.

Ola's solution is great and my org is testing it now, but in the mean time we're stuck with SSMS and all it's flaws. No offense intended, but how does this ^^^ help with the OP's (my) issue?

If anyone has found a resolution to this problem that actually involves correcting the problem, not avoiding it with other architectures, please chime in.

datwungai SSChasing Mays Points: 648 More actions · Answer 12

Found it!
Open the toolbox from the menu, then right-click in the toolbox and select "Show All".

Kevin3NF SSCarpal Tunnel Points: 4765 More actions · Answer 13

datwungai wrote:

Found it!
Open the toolbox from the menu, then right-click in the toolbox and select "Show All".

Thanks!

------------------------------------------------------------------------------------------------Standing in the gap between Consultant and ContractorKevin3NF DallasDBAs.com/Blog Why is my SQL Log File HUGE?!?![/url]The future of the DBA role...[/url]SQL Security Model in Plain English[/url]