Monday, January 10, 2011

How to Clear drop down list of Recent Connection from SQL Server Management Studio ?

http://sqlserver-training.com/how-to-clear-recent-sql-server-connection-list-from-ssms/-

Most Recent User Server List in SSMS drop down menu is known as MRU list.
SQL Server 2005
  1. Make sure that the "SQL Server management studio" is not opened
  2. Go to "Run"
  3. Type this command "%APPDATA%\Microsoft\Microsoft SQL Server\90\Tools\Shell\" and click "OK". This will open up the folder where this list is stored.
  4. Now search for the file "mru.dat" and rename this file.
  5. After renaming, launch the SQL Server management studio and you will not see any of the most recently used servers in the list.
For SQL Server 2008
  1. Make sure that the "SQL Server management studio" is not opened
  2. Go to "Run"
  3. Type this command "%APPDATA%\Microsoft\Microsoft SQL Server\100\Tools\Shell\" and click "OK". This will open up the folder where this list is stored
  4. Now search for the file "SqlStudio.bin" and delete / rename this file.
  5. After deleting, launch the SQL Server management studio and you will not see any of the most recently used servers in the list.

No comments:

Post a Comment