Clearing the Recent Servers List in SQL Server Management Studio

Introduction:

Here I will explain how to clear recent SQL server connection list from dropdown in SQL server management studio.

Description:

In previous articles I explained difference between view and stored procedure in SQL, difference between function and stored procedures, joins in SQL Server, substring function in SQL server and many articles relating to SQL server. Now I will explain how to clear recent SQL server connection list from dropdown in SQL server management studio.

While working with SQL server we will connect different servers using SQL server management studio. All the server connection names whatever we connected will be maintained in dropdown list and it will create confusion for us to know which database is working correctly. Our SQL server management studio connection window will be like this

To clear sql server connection servers from dropdown we need to remove “mru.dat” file from system folder. We can remove “mru.dat” file in different ways

First method go to “C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin” or “C:\Documents and Settings\[user]\Application Data\Microsoft\Microsoft SQL Server\100\Tools\ShellSEM\mru.dat or SqlStudio.bin”

Once we delete file our SQL server management studio window will be like as shown below

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email