Sunday, February 24, 2013

How to delete the server history list from SQL Management Studio 2008?

Especially if you are in an environment where you need to connect to several different DB servers, the list of server names in your SQL Management Studio (SSMS) may get lengthy and some may even become defunct.

The question is how do I delete them? The steps involved is actually quite simple (note this is for SSMS 2008).

  1. Go to %UserProfile%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell
  2. Find SqlStudio.bin file and delete it.

The server name list is now clean again.

SQL Management Studio 2008

No comments:

Post a Comment

Do provide your constructive comment. I appreciate that.