Feature
Expert-mode result sets that emit long SQL text (failing/long-running statistic commands, remediation SQL) return plain nvarchar columns — truncated and unclickable in SSMS grids. Wrapping these in FOR XML PATH [processing-instruction(query)] columns makes each one a single click to open, fully expanded, with formatting preserved. The technique is currently unused anywhere in the codebase.
Apply to command/remediation text columns in the expert-mode result sets; plain-text columns can remain alongside for programmatic consumers.
Feature
Expert-mode result sets that emit long SQL text (failing/long-running statistic commands, remediation SQL) return plain nvarchar columns — truncated and unclickable in SSMS grids. Wrapping these in
FOR XML PATH[processing-instruction(query)]columns makes each one a single click to open, fully expanded, with formatting preserved. The technique is currently unused anywhere in the codebase.Apply to command/remediation text columns in the expert-mode result sets; plain-text columns can remain alongside for programmatic consumers.