SQL Server 2008 Connect Login pulldown sizing

I am trying to find out how to increase the number if servers in my connect window.
My XP version allows the last 7 servers to show in the pulldown (see attached) while my Win7 version seems to only allow the last 3 servers to show in the list.

Where or How do I increase the the number of remembered entries on the Win7 version?
SQL-Load-Window.jpg
williambhowardjrAsked:
Who is Participating?
 
williambhowardjrConnect With a Mentor Author Commented:
Well, I didn't have mru.dat on either of my computers, however, further googling on mru.dat led me to find this file which I DID have: %APPDATA%\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin.

I couldn't edit it, however, I just copied "SqlStudio.bin" from my XP computer to the Win7 computer and now it also lists all 7 servers.

Thanks for all the help pushing me in the right direction..
0
 
ste5anSenior DeveloperCommented:
The number of servers depends on the servers recognized automatically and these ones where you already where logged into.
0
 
williambhowardjrAuthor Commented:
I've  logged into all 7 servers from both versions
0
 
DultonCommented:
See this post on how to "clear" this file which contains cached connections. It shows the location of this file.
http://blog.sqlauthority.com/2008/11/05/sql-server-clear-drop-down-list-of-recent-connection-from-sql-server-management-studio/


I checked mine out on my Visa OS, it's just XML. Don't see why you can't add the connection strings in you want from your XP machine to the Win 7 xml file and they'll appear.
0
 
williambhowardjrAuthor Commented:
While this answer solves *my* problem of getting all my servers to show up in the Win7 pulldown, it doesn't really address *how* someone can set the number of allowed items in the pulldown.

Also, it looks like  SSMS saves the connect info to "SqlStudio.bin", but I can't find any way to edit this file.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.