I am working with an older version of Microsoft SQL Server Management Studio 2014. I run the following query:
SELECT TOP 10 Q.* FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_query_plan( qs.plan_handle ) Q WHERE Q.dbid = DB_ID( 'Northwind' )
When I click on one of the hyperlinked query_plans (ShowPlanXML=...), SSMS 2014 opens the link in a new text window in XML format. As I understand it, SSMS is supposed to open the link as a graphical execution plan.
Is there any way to configure SSMS to automatically open the ShowPlanXML link as a graphical execution plan without third party software and without updating the version I have of SSMS 2014?