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-
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
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-
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