Tuesday, July 08, 2014

SOLUTION: SQL Server Management Studio 2012 Hangs after Opening Database Objects like Stored Procedure in Query Window

Today, I have started to experience that SQL Server Management Studio 2012 starts hanging after opening the stored procedure in Query Window. Here is the solution to fix this.


1. Close All Instances of SSMS 2012

2. In Run Command, type "%AppData%\Microsoft\SQL Server Management Studio" and it will open a folder like "C:\Users\{User Name}\AppData\Roaming\Microsoft\SQL Server Management Studio".

3. Rename the "11.0" folder to "11.0.Issue"

4. Open SSMS 2012 and new folder "11.0" would be created in the above path.

5. Open database objects like SP and don't see any hanging in SSMS 2012.

SOLUTION: Keyboard Shortcut not working in SQL Server Management Studio 2012

Today, I have started to experience that keyboard shortcuts not working in SQL Server Management Studio 2012. Here is the solution to fix this.


1. Go to Tools  --> Options
2. Select Environment --> Keyboard
3. In Right hand side, click RESET button.
4. Then, Keyboard shortcut works.