Skip to main content

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

Popular Posts

Ho Ching named 5th most powerful and is mistaken as first lady by Forbes

Forbes named Singapore Prime Minister wife and CEO of Temasek Holdings, Ho Ching, as the 5th most powerful woman in the world. Ho Ching is mistaken as Singapore's first lady! OMG!

I wonder how can Forbes makes such a blunder. For a complete list, refer to here.

How to stop FortiClient from starting automatically?

Installed FortiClient recently but the challenge in disabling the application/service from running automatically on every start-up annoyed me. Attempt to stop 'FortiClient Service Scheduler' only return 'Parameter is incorrect' error message.

An article on Technet help solve my trouble. To stop FortiClient from starting automatically, try the following:
Shut down FortiClient from the system tray.
Run net stop fortishield on command prompt.
Run msconfig.
On msconfig, switch to the Services tab. Clear the FortiClient Service Scheduler check box and click Apply.Run services.msc on command prompt to open up show all available services.Look for FortiClient Service Scheduler. Switch Startup type to Manual.Restart your computer. FortiClient should not be running automatically the next time round. Hope it helps.

President Elect Dr Tony Tan post election interview

I feel Dr Tony Tan can handle the reporters quite well.