[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 72
  • Last Modified:

SQL Server 2014: No Locals or Watch Window

Hi

This is going to seem really, really silly but, when I was upgraded to SQL Server 2014, I seemed to lose the locals and watch windows.  I've googled them and everyone says to go the Debug menu, click on Windows and select from there, but I only have Breakpoints, Output and Immediate.

Can anyone tell me how I can get them back please?

Thanks
Sarah
0
ScuzzyJo
Asked:
ScuzzyJo
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Those windows are only available in Debug mode and you can access them by the menu (Debug / Windows) or use the  following short keys:

Watch windows --> CTRL + ALT + W, 1 (or other number if you have more than one watch window)
Locals window --> CTRL + ALT + V, L

Note: Comma means a 2nd key stroke.
1
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Edit: I would first try the suggestions by Vitor. Try to see if using the keyboard combinations restores the windows.

Original Comment:
Does resetting Window Layout by going to Window -> Reset Window Layout help?
NOTE: Doing so will cause SSMS to "forget" all customization settings that you may have done.
0
 
ScuzzyJoAuthor Commented:
Thanks to both of you.  Vitor's worked.  It's weird that it doesn't show in the drop down menus though!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now