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
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
The number of servers depends on the servers recognized automatically and these ones where you already where logged into.
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.c om/2008/11 /05/sql-se rver-clear -drop-down -list-of-r ecent-conn ection-fro m-sql-serv er-managem ent-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.
http://blog.sqlauthority.c
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
Also, it looks like SSMS saves the connect info to "SqlStudio.bin", but I can't find any way to edit this file.