Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Sql Server Management Studio Object Explorer disappeared - missing - vanished

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!

like image 690
felbus Avatar asked Dec 22 '09 12:12

felbus


People also ask

How do I get the object explorer back in SQL Server?

Pressing the shortcut key F8. From the menus select View > Object Explorer as shown below.

How do I get the object explorer back in SQL Server 2012?

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.

How do I recover my SSMS?

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.


2 Answers

I just had this, and the menu option...

Window > Reset Window Layout

...worked a treat.

like image 164
andrewtatham Avatar answered Oct 16 '22 08:10

andrewtatham


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.

like image 4
WEFX Avatar answered Oct 16 '22 09:10

WEFX