SQL SERVER MANAGEMENT STUDIO 2012 PROFESSIONAL
Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,500 database tech articles on his blog at. Pinal has authored 13 SQL Server database books and 40 Pluralsight courses.
![sql server management studio 2012 sql server management studio 2012](https://www.sqlservertutorial.net/wp-content/uploads/Open-the-Connection-Dialog-300x213.png)
He holds a Masters of Science degree and numerous database certifications. Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 17 years of hands-on experience. Hope you have learned something new today! This came from feedback given to SQL Server Product group. This is not available in SQL 2008 R2 and its previous version. I have delete few from first screenshot taken and here is the modified version. We can’t be multi-select and has to be done one by one. To delete the servers from the list, highlight the name we want to delete (via keyboard or mouse) and then press delete key via keyboard. Note that delete file to get rid of server list is not officially supported by Microsoft.īetter way to achieve this is provided in SSMS 2012. Well, unofficially, you can delete the file directly which we found via ProcMon. So far, you might wonder, where is the new feature? I have been asked by many users to delete entries from SSMS “Connect to Server” server name list. %appdata%\Microsoft\Microsoft SQL Server \110\Tools\Shell\SqlStudio.bin %appdata%\Microsoft\Microsoft SQL Server \100\Tools\Shell\SqlStudio.binįor SQL Server 2012, here is what we can see in ProcMon
![sql server management studio 2012 sql server management studio 2012](https://static.filehorse.com/screenshots/developer-tools/sql-server-management-studio-screenshot-05.png)
SQL SERVER MANAGEMENT STUDIO 2012 WINDOWS
You can use one of my favorite tool from sysinternals called Process Monitor (also known as ProcMon) and easily figure out that this is stored in a file under your windows user profile.īelow is the file in SQL 2008 R2 Management Studio. What you would do if you want SQL Server Management Studio to forget “all” the servers listed in drop down of Server name? To do that, you need to know how and where it’s stored. Whatever servers you have connected, it would be stored by management studio. Do you know that your server name is saved in management studio? Of course, very useful feature because you may not like to type server name/IP address every time. Once you login to SQL, do your work and close the management studio. Many times, DBA have to login to production server from non-regular machine, may be a developer’s workstation. Well, continue reading and you would get the answer. You might have seen below screen countless times and you might wonder what is there is blog about in this simple screen. On the similar lines, this blog is going to show little less known new feature of login main screen (“Connect to Server”) of SSMS 2012. In one of my previous guest blog on SQL Authority, I wrote about “Additional Connection Parameter” tab of login screen in SQL Server Management Studio (a.k.a. Let us read the entire blog post in the voice of the Balmukund himself. Well, here is the blog post about the same very popular UG session. He had presented a fantastic session in our last UG and there were lots of requests from attendees that he blogs about it.
![sql server management studio 2012 sql server management studio 2012](https://i.stack.imgur.com/1PJEX.png)
This is a fantastic blog post from my dear friend Balmukund ( blog | twitter | facebook ).