Monday, March 12, 2012

How to get rid of unused servers in SSMS?

In Connect to Server dialog box in SQL Server Management Studio, it has a drop-down box with a list previously connected servers. However, some of these servers are not used anymore. I want to get rid of them in order to make a room for new server names. So far I could not find a way how to do this, apparently SQL Server does not store these values in the Registry. Is there a way to get rid of them ?

Thanks.

I looked earlier today for you and like you it appears the registry is not the "store" for this data. Upon looking through all of the "known" sql directories my hunch (though I cannot find it) would be that its somewhere at C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE.|||

You can blow away all your Most Recently Used lists (including MRU connections) by deleting c:\Documents and Settings\<you>\Application Data\Microsoft SQL Server\90\Tools\Shell\mru.dat while Management Studio is not running. Management Studio will recreate the file the next time it starts.

Hope this helps,
Steve

No comments:

Post a Comment