Subscribe

SQLServer-DBA.com Links

Subscribe to newsletter

Dba_db2_button

Powered by TypePad
SQL Server - Clear list of server names on SQL Server Management Studio

22 October,2012 by Jack Vamvas

Sometimes there is a requirement to clear down the Server Name items on the SQL Server Management Studio Connect to Server GUI. 

 The method used is slightly different for versions of SQL Server Management Studio. These are undocumented processes and there is guarantee they are available in future versions. It’s unclear what other data is deleted.

 Ssms_server_name

 How to clear the list

Shut down all SSMS instances on the server
Delete/Rename the file
Open SSMS

 
 

For SQL 2005, delete the file:

C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

For SQL 2008, the file location, format and name changed:

C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin




For Windows 7, it's in the following:

SQL 2005:
C:\Users\\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

SQL 2008:
C:\Users\\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

 Related Posts

SQL Server - Open SSMS on the Command Line

SQL Server – Open SSMS without the splash screen graphic


Author: Jack Vamvas (http://www.sqlserver-dba.com)

******** *******

Subscribe to SQLServer-DBA.com

Latest posts delivered to you daily

Delivered by FeedBurner

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer