Absolute Thoughts....

  Home  |   Contact  |   Syndication    |   Login
  9 Posts | 0 Stories | 12 Comments | 0 Trackbacks

News

Archives

Post Categories

If you are using SQL Server management Studio much the we can observer that the list of server names in the log in of it. As you can imagin a period of time after 6 month or 1 year you will see a long list of server names in the login dialog.

How to clear this list...?

I doesn't provide a mechanism to clean nor clear the list, so you'll have to do a little browsing through your file system.

For SQl Server 2005 Management Studio, we should delete the below file
C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat.

For SQl Server 2008 Management Studio, we should delete the below file
C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\SQLStudio.bin.


After deletion we can re-login the Management studio and can see the empty list.

posted on Wednesday, March 9, 2011 8:56 PM

Feedback

# re: How to clear the server name list in SQL Server Management Studio 2005 8/12/2011 4:21 PM Revanth
How to clear a server name in SQL 2005.

Post A Comment
Title:
Name:
Email:
Comment:
Verification: