|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server Management Studio Server ListIn SQL Server 2005 Management Studio, the Connect to Server dialog has
a combobox for "Server name" that remembers any servers I have ever connected to. Some of those servers no longer exist. Is there a way to remove entries? You can close SSMS, rename mru.dat (you'll need to search for this file, and
it may be hidden, I forget). Caution! This will delete all your servers (you can't pick and choose). Also note, this no longer works in SQL Server 2008 SSMS AFAICT. On 3/17/09 6:58 PM, in article iea0s4t6cfl49v1isl78q3r7vgkqgii***@4ax.com, Show quoteHide quote "Jack Jackson" <jjackson-***@cinnovations.net> wrote: > In SQL Server 2005 Management Studio, the Connect to Server dialog has > a combobox for "Server name" that remembers any servers I have ever > connected to. > > Some of those servers no longer exist. Is there a way to remove > entries? > Also note, this no longer works in SQL Server 2008 SSMS AFAICT. The filename for SSMS 2008 is SqlStudio.bin. Equally unsupported (it has worked for me, though). -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message news:C5E5B9C0.13523%ten.xoc@dnartreb.noraa... > You can close SSMS, rename mru.dat (you'll need to search for this > file, and > it may be hidden, I forget). > > Caution! This will delete all your servers (you can't pick and > choose). > > Also note, this no longer works in SQL Server 2008 SSMS AFAICT. > > > > > > > On 3/17/09 6:58 PM, in article > iea0s4t6cfl49v1isl78q3r7vgkqgii***@4ax.com, > "Jack Jackson" <jjackson-***@cinnovations.net> wrote: > >> In SQL Server 2005 Management Studio, the Connect to Server dialog >> has >> a combobox for "Server name" that remembers any servers I have ever >> connected to. >> >> Some of those servers no longer exist. Is there a way to remove >> entries? > Thanks to both of you, that worked fine.
Fortunately I only had a couple servers that I wanted to keep. On Tue, 17 Mar 2009 20:34:08 -0400, "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote: Show quoteHide quote >You can close SSMS, rename mru.dat (you'll need to search for this file, and >it may be hidden, I forget). > >Caution! This will delete all your servers (you can't pick and choose). > >Also note, this no longer works in SQL Server 2008 SSMS AFAICT. > > > > > > >On 3/17/09 6:58 PM, in article iea0s4t6cfl49v1isl78q3r7vgkqgii***@4ax.com, >"Jack Jackson" <jjackson-***@cinnovations.net> wrote: > >> In SQL Server 2005 Management Studio, the Connect to Server dialog has >> a combobox for "Server name" that remembers any servers I have ever >> connected to. >> >> Some of those servers no longer exist. Is there a way to remove >> entries? If you'd like to help contribute to fixing this behavior in a future
release, please vote on it (I filed a Connect item earlier today): http://is.gd/nS6E Show quoteHide quote > Thanks to both of you, that worked fine. > > Fortunately I only had a couple servers that I wanted to keep. Done
On Wed, 18 Mar 2009 14:22:55 -0400, "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote: Show quoteHide quote >If you'd like to help contribute to fixing this behavior in a future >release, please vote on it (I filed a Connect item earlier today): > >http://is.gd/nS6E > > > > >> Thanks to both of you, that worked fine. >> >> Fortunately I only had a couple servers that I wanted to keep. >  
Other interesting topics
SSMS 2008 Super Buggy
How do I shrink or drop a transaction log and still be able to do backup and recovery Why I cannot see log in Management Studio log file viewer? New Schema Design Can not create relationship; SQL server 2008 Express Moving SQL Server Tools Installation to a New Drive statistics for performance Maintenance plan logging forgot password Management Studio 2005 fails to start - How to fix? |
|||||||||||||||||||||||
