dbTalk Databases Forums  

SQL Server Management Studio Server List

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss SQL Server Management Studio Server List in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jack Jackson
 
Posts: n/a

Default SQL Server Management Studio Server List - 03-17-2009 , 04:58 PM






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?

Reply With Quote
  #2  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: SQL Server Management Studio Server List - 03-17-2009 , 06:34 PM






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 iea0s4t6cfl49v1isl78q3r7vgkqgiikg8 (AT) 4ax (DOT) com,
"Jack Jackson" <jjackson-nsp (AT) cinnovations (DOT) net> wrote:

Quote:
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?


Reply With Quote
  #3  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: SQL Server Management Studio Server List - 03-18-2009 , 05:59 AM



Quote:
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).

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Aaron Bertrand [SQL Server MVP]" <ten.xoc (AT) dnartreb (DOT) noraa> wrote in
message news:C5E5B9C0.13523%ten.xoc (AT) dnartreb (DOT) noraa...
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
iea0s4t6cfl49v1isl78q3r7vgkqgiikg8 (AT) 4ax (DOT) com,
"Jack Jackson" <jjackson-nsp (AT) cinnovations (DOT) 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?




Reply With Quote
  #4  
Old   
Jack Jackson
 
Posts: n/a

Default Re: SQL Server Management Studio Server List - 03-18-2009 , 12:12 PM



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 (AT) dnartreb (DOT) noraa> wrote:

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 iea0s4t6cfl49v1isl78q3r7vgkqgiikg8 (AT) 4ax (DOT) com,
"Jack Jackson" <jjackson-nsp (AT) cinnovations (DOT) 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?

Reply With Quote
  #5  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: SQL Server Management Studio Server List - 03-18-2009 , 12:22 PM



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




Quote:
Thanks to both of you, that worked fine.

Fortunately I only had a couple servers that I wanted to keep.



Reply With Quote
  #6  
Old   
Jack Jackson
 
Posts: n/a

Default Re: SQL Server Management Studio Server List - 03-18-2009 , 03:53 PM



Done

On Wed, 18 Mar 2009 14:22:55 -0400, "Aaron Bertrand [SQL Server MVP]"
<ten.xoc (AT) dnartreb (DOT) noraa> wrote:

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.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.