Most Recent User Server List in SSMS drop down menu is known as MRU list.
SQL Server 2005
- Make sure that the "SQL Server management studio" is not opened
- Go to "Run"
- 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.
- Now search for the file "mru.dat" and rename this file.
- After renaming, launch the SQL Server management studio and you will not see any of the most recently used servers in the list.
- Make sure that the "SQL Server management studio" is not opened
- Go to "Run"
- 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
- Now search for the file "SqlStudio.bin" and delete / rename this file.
- 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