Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Welcome to my blog. I work as Database lead at Synaptic Digital. Hope you find some interesting stuff here.
Browse by Tags · View All
BRH 17
SQL Server 15
#SQL Server 11
#BI 10
#TSQL 8
TSQL 8
BI 7
SSRS 6
#SQLServer 6
SSRS 2008R2 5

Archive · View All
January 2011 6
December 2010 5
September 2012 4
May 2012 4
March 2011 4
November 2012 2
October 2012 2
January 2012 2
February 2011 2
November 2010 2

Remove the server name from MRU list from SSMS "connect to server" dialog

Oct 17 2012 12:00AM by Chintak Chhapia   

In SSMS 2005 and SSMS 2008 the method to clear the server name from "connect to server" dialog is to close SSMS and remove mru.dat ( in case of 2005) or SqlStudio.bin ( in case of 2008 and 2008 R2).  This method has been documented here.

Below are the default location of these files
C:\Documents and Settings\<USER>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat
C:\Documents and Settings\<USER>\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

The biggest problem of deleting this file is we also loose the server names which we do not want to remove.  In SSMS 2012 there is documented way to delete the server name from "connect to server" dialog. Now, we can remove the server name by selecting it and pressing DELETE. 

Now in SSMS "connect to server"  dialog, navigate to the particular server with keyboard

image

Press “DELETE”. Now this server will be removed from list.

image

Please note that when you again connect to the server you removed, it will again added to MRU list and you again need to delete it.

References:-

1. http://sqlblog.com/blogs/aaron_bertrand/archive/2009/03/18/managing-the-mru-list-for-the-connect-to-server-dialog-in-ssms.aspx

2. http://blogs.msdn.com/b/managingsql/archive/2011/07/13/deleting-old-server-names-from-quot-connect-to-server-quot-dialog-in-ssms.aspx

Tags: 


Chintak Chhapia
40 · 5% · 1477
4
 
0
Lifesaver
 
 
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"Remove the server name from MRU list from SSMS "connect to server" dialog" rated 5 out of 5 by 4 readers
Remove the server name from MRU list from SSMS "connect to server" dialog , 5.0 out of 5 based on 4 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]