Search code examples
sql-server-2008ssms

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

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!

Solution

  • 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.