Customize Menu and Toolbar in SQL Server 2012

Here, we will take a look at how to customize the SQL Server Management Studio for our own convenience. In SQL Server 2012, if we want to customize a menu and toolbar, that is simple to do visually using SQL Server Management Studio.  So let's take a look at a practical example of how to customize a menu and toolbar in SQL Server 2012. The example is developed in SQL Server 2012 using the SQL Server Management Studio. These are the simple steps to customize a menu and toolbar. 

Now open a SQL Server Management Studio window. Use Start -> All Programs -> Microsoft SQL Server 2012 -> Microsoft SQL Server Management Studio.

Now select Tools -> Customize from the menu.

Customizemenuoptioninsqlserver.jpg

Now click on the option customize or press (Alt+T+C) to open the customize window directly; see:

customizewindowinsqlserver.jpg

Now the customize window has two tabs; one for toolbars and another for commands. If suppose you click on the checkbox of debug from the toolbar tab items, then it will add the debug option to the toolbar.

adddebugintoolbarinsqlserver.jpg

We can also add a new Toolbar name using the New Button from the customize window and also you can set the dock location. To select a dock location click on the modify selection and select Dock Location: Left

Docklocationoftoolbaritemsinsqlserver.jpg

Now Toolbar Debug will be added to the left side.

Toolbarwithdebuginsqlserver.jpg

Now click on the second tab commands and the commands window will be opened.

commandwindowinsqlserver.jpg

The preceding commands window has three options; one for rearranging the Menu Bar, the second for the ToolBar and the third for the ContextMenu; by default it sets on Menu Bar expend it and select option

menubarinsqlserver.jpg

Suppose we want to delete a file from the menu bar. Select the file and click on the delete button. Now the Menu Bar looks as in the following without the File option:

menubarwithoutfileoptioninsqlserver.jpg

Similarly we can select the ToolBar to add, select, delete or reset all the options in the ToolBar.

ToolBarcommandinsqlserver.jpg

Similarly we can select Context Menu to add, select, delete or reset all the options from the Context Menu.

contextmenucommandinsqlserver.jpg

Similar Articles