All we need is an easy explanation of the problem, so here it is.
I am assuming that the Toolbox windows in SSMS is used to store code samples. So I am able to highlight code in the editor and drag it to the Toolbox window.
However, if I wanted to use the code sample and drag it back onto the editor (or double click on it), I can’t. All entries in the Toolbox are grayed out. And when I drag an entry, it turns the mouse cursor into a stop sign.
What do I need to do to enable this functionality?
I got those two entries there by highlighting some code in the editor, then dragging it to the area under Samples. First it shows up as actual text that you dragged. But you can right-click, select Rename and give it a friendly name.
Using SSMS v17.9.1 and the only add-in installed in SQL Prompt 8.
The only workaround that works is clicking on the entry, Ctrl+C, then pasting it into the editor.
To actually display Maintenance Plan Tasks, you have to right-click and select Show All.
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
After your updated comment, I believe my understanding is correct, that the Toolbox was only ever implemented to be used with the Maintenance Plan designer at this point. It’s briefly mentioned in the Microsoft Books Online Use the Toolbox. My guess is they may have designed the Toolbox to be flexible should they implement it for other scenarios, but at this point I think Maintenance Plans is the only one, and I don’t believe it’s (natively) possible to enable it in other contexts of SSMS.
Sorry, that would’ve been cool. But something pretty similar to what you’re trying to accomplish does exist in SSMS, called Code Snippets which that linked article goes through, and shows you how to customize with your own snippets via XML.
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂