The SQL Server Management Studio Object Explorer
menu disappeared. The shortcut F8
and the view->object explorer
method neither do anything. I have clicked everything on the keyboard, googled around, but nothing.
I really need this back, it's a massive hassle having to navigate through the summary window without the object explorer tree view!
Pressing the shortcut key F8. From the menus select View > Object Explorer as shown below.
Just open SQL server management studio. On the menu bar, select Window, then Reset Window Layout. This will place object explorer to its original position.
All you have to do is reopen SSMS and you're presented with the 'Microsoft SQL Server Management Studio Recovered Files' window. Simply clicking 'Recover Select Files' will open a temporarily saved copy of the Query window. Here's the saved script including formatting.
I just had this, and the menu option...
Window > Reset Window Layout
...worked a treat.
I have seen this same problem when double-clicking on a SQL file when SSMS is not already open. When this happens, an SSMS console gets opened automatically, but none of the windows are present, and some of them cannot be enabled. To avoid this, simply open SSMS first, and THEN click on the SQL file you were trying to open.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With