How do I reorder/clear the connection history in SQL Management Studio 2008?

Question

I connect to a lot of different servers in SQL Management Studio, but I find that not only is there no way to delete the old connections (dbnames, usernames, etc.), they also start to show up as duplicates.

Is there any way to clear them/reorder the history? I can't seem to find any easy way.

Thanks! Chris

Answer 1

Have a look at the DialogSettings.xml and mru.dat files in your %AppData%\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM directory. I haven't tried tinkering with mine yet, but they look like they've got the relevant information in.

I suggest you back them up first though!

Answer 2

I don't see an accepted answer, so I'll add my 2 cents. I had the same issue and found the file in question is SqlStudio.bin. I'm not sure how you'd go about editing it, but if you re/move it, you get a blank slate for your SQL connections.

We still use XP here at work, so the file is located in the C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell folder.