Improve your skills

July 11, 2016

How to Clear/Remove Recent or Saved Connection Server Name From Drop Down List in SQL Server Management Studio

Sometimes we want to delete the saved server name from the list. there are two ways to delete the name.

1. Using DELETE key form keyboard-
By using this method we can remove the saved server name from the list. First we click on the list. 
Hover over the server name you want to delete via mouse or Select server name via keyboard. As shown in the image below-


How-to-Clear-or-Remove-Recent-or-Saved-Connection-Server-Name-From-Drop-Down-List-in-SQL-Server















Now press the DELETE key on the keyboard, the server name will be deleted from the list. We can delete as many server names as we want.



2. By delete the file from SSMS location-
Delete the file from the given path:

Note:
1. Before delete the file please close SQL Server Management Studio if it currently running.
2. This process resets all of your customized settings (Transaction Isolation Level, Results or Text Editor settings, etc.).

In SQL Server 2005:
C:\Documents and Settings\<username>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

In SQL Server 2008:
C:\Documents and Settings\<username>\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

In SQL Server 2008 standard/SQL Express 2008:
C:\Documents and Settings\<username>\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

In SQL Server 2012:
C:\Users\<username>\AppData\Roaming\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin

In SQL Server 2014:
C:\Users\<username>\AppData\Roaming\Microsoft\SQL Server Management Studio\12.0\SqlStudio.bin



0 comments:

Post a Comment

Subscribe for Latest Update

Popular Posts