Clear Recent SQL Server Connection List From SSMS

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/ View all posts by Mustafa EL-Masry

Leave a Reply Cancel reply

Enter your comment here...

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

Email (required) (Address never made public)

Name (required)

Website

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

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

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

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.

it Tutorial

Merge Join Cartesian in Oracle July 17, 2021

I will explain Merge Join Cartesian in Oracle in this post. Merge Join Cartesian in Oracle If you forget to use any WHERE Clause in the Join Condition, Probably Oracle will use the Merge Join Cartesian an this will affect the SQL Performance because The most expensive and bad join type is Merge Join … The post Merge Join Cartesian in Oracle appeared first […]

Mehmet Salih Deveci

Alert Log file location in Oracle July 17, 2021

I will explain Alert Log file locations in Oracle in this post. Alert Log file locations in Oracle Alert log file is most important log file for Oracle DBAs, because this file includes chronological log of messages and errors of Oracle database like startup, shutdown, log switches, partition add , session kill and etc. … The post Alert Log file location in […]

Mehmet Salih Deveci

Listener Log file location in Oracle July 17, 2021

I will explain Listener Log file location in Oracle in this post. Listener Log file location in Oracle Listener log file locations are very important for us. If you want to learn where listener log file location is, execute the lsnrctl status command as follows. [oracle@msdbdbadm01 admin]$ lsnrctl status LSNRCTL for Linux: … The post Listener Log file […]

Mehmet Salih Deveci

SQL*Net message from client wait in Oracle July 16, 2021

I will explain SQL*Net message from client wait in Oracle in this post. SQL*Net message from client wait in Oracle Most used wait event in the 10046 trace or AWR Report is the SQL*Net message from client wait event that can indicate a possible NETWORK problem on Server or Database. If you saw this … The post SQL*Net message from client wait in Oracle appea […]

Mehmet Salih Deveci

GV$ARCHIVED_LOG AND GV$LOG_HISTORY Views in Oracle July 15, 2021

I will explain GV$ARCHIVED_LOG AND GV$LOG_HISTORY Views in Oracle in this post. gv$archived_log view in Oracle V$Archived_log and gv$archived_log views are one of the most important views for DBAs that includes archive log names and archived log information from the control file. An archive log record is inserted after the online redo log is successfully … […]

Mehmet Salih Deveci

Clear Recent SQL Server Connection List From SSMS

Share this:

Like this:

Related

Published by Mustafa EL-Masry

Leave a Reply Cancel reply