July 13, 2010 at 6:14 am
I've looked for a way to remove the unused or unwanted connections in the drop down list that appears when I start SSMS. I have found references that recommend removing "SqlStudio.bin" and "mru.dat" but haven't been able to locate either file on my pc.
September 2, 2010 at 2:12 pm
If you are using Vista or Windows 7, it will be located here:
C:\Users\<username>\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell
Unfortunately, it's an all or nothing solution. Here's a reference:
September 3, 2010 at 5:20 am
I'm using XP and can't find the mru file anywhere
September 3, 2010 at 9:44 am
What version/edition of SQL Server Management Studio are you using?
September 3, 2010 at 9:48 am
MS SQL 2008 Standard
September 3, 2010 at 9:52 am
To find the version of SSMS, open SSMS, go to Help, then About.
September 3, 2010 at 9:55 am
Microsoft SQL Server Management Studio10.0.1600.22 ((SQL_PreRelease).080709-1414 )
September 3, 2010 at 10:02 am
Since you're on XP and using SSMS 2008, here's the file you should be looking for:
C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin
September 3, 2010 at 11:47 am
I was not able to find this file either.
September 3, 2010 at 11:52 am
Ignore that last response, I found it. Problem solved. Thanks for the help. Your timing was perfect, I was the victim of a self-inflicted MSSQL wound yesterday. I really needed to get the production server out of the dropdown list.
July 11, 2011 at 8:06 am
And if you're on Vista or Windows 7, the path becomes
C:\Users\<username>\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply