How to add custom SP calls to SSMS toolbar

Question

Recently I've found out, that there's an option to include most commonly used queries to be executed by clicking a button on SSMS toolbar.

You can do that by following these steps:

1. Right mouse click on toolbar
2. Click Customize
3. Create new toolbar
4. Modify it
5. Add Command
6. Under Query categories there's option to add up to 9 Custom SPs

Now when I came here, things look like that:

However I'm struggling on how to add the actual procedure, that needs to be executed.

There's an option to add multiple SPs:

1. Custom SP 1
2. Custom SP 2
3. ...
4. sp_help
5. sp_lock
6. sp_who

How do I assign my procedure to be Custom SP 1, for instance?

To be clear: My goal is to have a button in SSMS toolbar, which would execute my desired procedure (query) on click.

Answer 1

This is a great question imo, but to do this it's an awful way you'll have to go.

Unfortunately i have the German version of SSMS, so my screens might confuse you a little.

Following you can see a guide:

The Options-Window

Select a free Shortcut

Assign to Toolbar

This seems a bit uncomfortable, but this is the only way i know / can imagine on how to do this.

Let me know if this helps! Cheers

Answer 2

English version of SSMS Go to Tools-> options

Answer 3

I found that I needed to offset the "Custom SP #" button by 1.
ie I've assigned a command to Query Shortcut "Ctrl + 9" which will be run when I use the "Custom SP 8" command to add to the toolbar.