Change Setting for Recently Used Files in SQL Server Management Studio SSMS

By:   |   Updated: 2011-04-08   |   Comments   |   Related: More > SQL Server Management Studio


I noticed in SSMS that there is the ability to show recently used files. Is there a way to configure this to show more or less recently used files?

Often we have a set list of files containing queries that we use. You could use the File > Open option in SSMS, but there is also File > Recent Files through which we can open recently used files directly without going to the particular location of the file. The below screenshot shows my recently used files. In this tip I will show how we can increase or decrease the number of files shown under Recent Files.

how to increase or decrease the number of files shown under recent files in ssms

Steps to change Recent Files number

Step 1
First check the current value for the Recent File option. Go to Tools > Options > General. You can see Display files in recently used list option as shown below. On my machine the value is 4 filest that can be displayed in Recent Files. This value can be changed from 1 to 24. That means we can display 1 to 24 recently used files.

steps to change the recent files number in ssms

We can validate this by checking the recently used file list through Files > Recent Files.

steps to change the recent files in ssms

Step 2
Customize this number as per your requirement. Here I am changing this value to 12 for my needs.

if you opened less files than the number you have set, ssms will only show those opened via ssms

Step 3
Verify that the Recent Files option now shows 12 files. (Note: if you have opened less files than the number you have set, SSMS will only show those files that you opened via SSMS.)

verify that the recent files option shows the value you set

Next Steps

Last Updated: 2011-04-08

get scripts

next tip button

About the author
MSSQLTips author Jugal Shah Jugal Shah has 8+ years of extensive SQL Server experience and has worked on SQL Server 2000, 2005, 2008 and 2008 R2.

View all my tips
Related Resources

More SQL Server Solutions

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

Email me updates

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Recommended Reading

Display Line Numbers in a SQL Server Management Studio Query Window

Connect to SQL Servers in another domain using Windows Authentication

SQL Server Management Studio Keyboard Shortcuts - Complete List

Line Split Issues when Copying Data from SQL Server to Excel

Different Options for Query Results in SQL Server Management Studio

get free sql tips
agree to terms

Learn more about SQL Server tools