SQL Server 2014:  No Locals or Watch Window

Posted on 2016-09-14
Medium Priority
Last Modified: 2016-09-14

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?

Question by:ScuzzyJo
LVL 54

Accepted Solution

Vitor Montalvão earned 2000 total points
ID: 41797640
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.
LVL 14

Expert Comment

by:Nakul Vachhrajani
ID: 41797647
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.

Author Closing Comment

ID: 41797658
Thanks to both of you.  Vitor's worked.  It's weird that it doesn't show in the drop down menus though!

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Microsoft provides a rich set of technologies for High Availability and Disaster Recovery solutions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question