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

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.

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.

While this doesn't really let you tinker with the usernames, once you reset the file the passwords get memorized correctly. Thanks! – Chris Oct 23 '09 at 15:44 1 In Windows 7: C:\Users\%USERNAME%\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell – Chris Feb 22 '10 at 21:58.

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!

I think you can leave out "Roaming" in "%AppData%\Roaming\Microsoft..." so it would be "%AppData%\Microsoft..."; At least in Vista. – Sung Mar 26 '09 at 0:02 Ironically, I didn't realise that "%AppData%" would actually work directly - it was meant to be a sort of "meta replacement" - for instance, my directory is c:\Users\Jon\AppData\Roaming. Thanks for the hint though - will edit.

– Jon Skeet Mar 26 '09 at 6:21 Doesn't work for 2K8, that might be a 2K5 thing. – Chris Apr 2 '09 at 19:04 Chris, are you still working on this? I've got a new netbook which I wouldn't mind install SQL Server Express 2008 (+studio) on, if you'd like me to investigate further.

– Jon Skeet Apr 2 '09 at 19:22 Yes. I searched the registry and everything under SQL Server for a mention of my server's name and didn't find it, so now I'm thinking it's in profile now...but yes, if you find anything else that would be great. – Chris Apr 2 '09 at 20:33.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.