SQL SERVER – A Cool Trick – Restoring the Default SQL Server Management Studio – SSMS
- by pinaldave
“I do not know where my windows went!”
“I just closed my object explorer and now I cannot find it.”
“How do I get my original windows layout back in SQL Server Management Studio?”
“How do I get the window which was there in left side back again?”
Since last 2-3 years, every single day I receive more than 5 emails on SSMS and its layout. For the beginners it is very common to get confused when they attempt to change SQL Server Management Studio’s windows layout. They often change the layout and are not able to get the original layout back. Often people do not change the layout whole of their life, leading to uncomfortable feeling when they go to another’s computer where the windows are differently placed.
Today’s blog post is dedicated all the beginners in SQL Server. It is extremely simple to reset the SSMS layout to default layout. The default layout involves 2 major things 1) Object Explorer on left side 2) Query Windows on right side (80% screen estate). Personally I am so used to this as well that if there is any other changes in the same, I do not enjoy working on the environment.
Well, the solution to rest the SSMS layout is very simple. One can do it in split seconds. To restore the default configuration, on the Window menu, click Reset Window Layout.
Have you ever used this feature? Do you feel uncomfortable when SSMS layout is not in default state? How do you address this situation?
Reference: Pinal Dave (http://blog.sqlauthority.com)
Filed under: PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology
