SSMS 2016 "Open recent" menu doesn't show recently saved files - by Brent Ozar

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


129
0
Sign in
to vote
ID 3113288 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 11/27/2016 6:16:19 AM
Access Restriction Public

Description

In SSMS 2016 13.0.16000.28, connected to SQL Server 2016 SP1, if you click File, Save As, and save an execution plan, it doesn't show up in the Open Recent menu.

It's especially painful given this other bug, which requires users to save the XML query plan as a sqlplan file in order to view the graphical plan:
https://connect.microsoft.com/SQLServer/feedback/details/3113287

To reproduce it, run this query:

DBCC FREEPROCCACHE
GO
SELECT * FROM sys.databases
GO
SELECT 
st.text AS QueryText,
qp.query_plan AS QueryPlan
FROM sys.dm_exec_cached_plans AS cp
CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) AS qp
CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) AS st
GO

Click on the query plan. It shows up as an XML document rather than a graphical plan (that problem is bug 3113287). Click File, Save As, and name it as "my beautiful plan.sqlplan" so that you can view it graphically later. Close it.

Then click File, Open Recent, and "my beautiful plan.sqlplan" isn't in the recent files list - even though it was just saved.
Sign in to post a comment.
Posted by Microsoft on 1/23/2017 at 8:29 PM
This issue was fixed in the recently released SSMS 16.5.2 (https://msdn.microsoft.com/en-us/library/mt238290.aspx)

Thanks,
-Matteo