How to remove SQL Server name from drop down in management studio
In SQL Server 2008/2005 Management Studio, during the login process there is an input text box called “Server Name”. This is a drop-down which stores a history of servers that you have previously connected to.
This article shows how to remove a server from the drop down history
- Close the Management Studio Application (SSMS)
- Delete relevant file as follows:
For SQL 2005:
C:Documents and SettingsApplication DataMicrosoftMicrosoft SQL Server90ToolsShellmru.dat
For SQL 2008:
C:Documents and SettingsApplication DataMicrosoftMicrosoft SQL Server100ToolsShellSqlStudio.bin
- Reopen Management studio.
How useful was this post?
Click on a star to rate it!
Average rating / 5. Vote count:
No votes so far! Be the first to rate this post.