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.

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

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

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

Now Toolbar Debug will be added to the left side.

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

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.

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:

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

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