Link to home
Start Free TrialLog in
Avatar of williambhowardjr
williambhowardjr

asked on

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
Avatar of ste5an
ste5an
Flag of Germany image

The number of servers depends on the servers recognized automatically and these ones where you already where logged into.
Avatar of williambhowardjr
williambhowardjr

ASKER

I've  logged into all 7 servers from both versions
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.
ASKER CERTIFIED SOLUTION
Avatar of williambhowardjr
williambhowardjr

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.