SQL Server 2005

1.Make sure that the “SQL Server management studio” is not opened
2.Go to “Run”
3.Type this command “%APPDATA%\Microsoft\Microsoft SQL Server\90\Tools\Shell\” and click “OK”. This will open up the folder where this list is stored.
4.Now search for the file “mru.dat” and rename this file.
5.After renaming, launch the SQL Server management studio and you will not see any of the most recently used servers in the list.

 SQL Server 2008

1.Make sure that the “SQL Server management studio” is not opened
2.Go to “Run”
3.Type this command “%APPDATA%\Microsoft\Microsoft SQL Server\100\Tools\Shell\” and click “OK”. This will open up the folder where this list is stored
4.Now search for the file “SqlStudio.bin” and delete / rename this file.
5.After deleting, launch the SQL Server management studio and you will not see any of the most recently used servers in the list.


SQL Server 2012

view this video because in 2012 it’s very easy you can clear it from the SQL Server management Studio

Published by Mustafa EL-Masry

I am Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I do it in multiple customers here in KSA and as of now, I am working in Bank Albilad managing the core banking system that is hosted in SQL Server Database 8 TB. Also, I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) For more information check my page https://mostafaelmasry.com/about-me/

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Google photo

You are commenting using your Google account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.