SQL: SQL Server Management Studio – Clear Recent Server List

SQL Server Management Studio will store the names of the servers you have connected to so that you can easily connect at a later date without having to re-enter the IP Address or name of the server. This is a great feature but sometimes my list gets populated with a bunch of servers that I don’t use frequently. Unfortunately, there is no tool that can be used to clear out the list. Luckily there is still a way to accomplish this. Just navigate to the corresponding directory below, depending on your operating system, and delete the SqlStudio.bin file.

Windows XP
C:\Documents and Settings\[User Name]\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell

Windows 7
C:\Users\[User Name]\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell

After deleting the SqlStudio.bin file, the list will be cleared.

SQL Server Management Studio 2005 Users: If you are using SQL Server Management Studio 2005 then the file you will delete is named mru.dat. Further, to find the file replace 100 with 90 in the above file paths.

Posted in SQL. Tags: , . Leave a Comment »

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: