Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

Clearing the Recent Servers List in SQL Server Management Studio

Mar 6, 2014
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 RSS subscribe by email Subscribe by Email

1 comments :

Rikin Patel said...

If some one want to remove some item from history then go below link and more details.

http://csharpsqllearning.blogspot.in/2013/02/removing-server-name-from-ms-sql-server.html

Give your Valuable Comments

Note: Only a member of this blog may post a comment.

© 2015 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.