In SSMS (SQL Server Management Studio) there is a meny item Available Databases. I would like to increase the size of that box since there is some databases with long name that I would like to see the whole name. Production name "VeryLongNameOfADatabaseInThisCase_Prod" "VeryLongNameOfADatabaseInThisCase_TEST".
-
Do you mean that you want to expand the right-hand panel which lists out databases on an instance? If so, you can move the panel slider to the right to resize the 'Object Explorer' panel. Alternatively, you can snap it out to have it on another window/screen. A screenshot of your issue would help.– spikey_richieCommented Jan 25, 2019 at 9:39
-
No, mean up in the menu.– PeterCommented Jan 26, 2019 at 13:36
-
You're not making this easy Peter... Can you be more specific please, with some screenshots?– spikey_richieCommented Jan 28, 2019 at 8:41
-
How do I add screen shots? OPEN SSMS. On the first meny row you have File, Edit, View, Query...– PeterCommented Jan 29, 2019 at 9:43
-
How do I add screen shots? OPEN SSMS. On the first meny row you have File, Edit, View, Query...– PeterCommented Jan 29, 2019 at 9:45
|
Show 2 more comments
1 Answer
- Navigate to Tools > Customize
- Go to the 'Commands' tab
- Change the radio buttons on the left to 'Toolbar'
- Select 'SQL Editor' from the list of options
- Highlight 'Available Databases [__________]
- Click 'Modify Selection'
- Change the 'Width' property from 160 to a more meaningful value
- Click Close
Hey presto, your Databases drop-down list is now wider.