Patch My PC Feature and Application Request

A community where customers and the community can provide feedback to make a better product for everyone! For more details on how we prioritize request, please see:

Detect SQL version and install different version of reports

Older versions of SQL do not support the legacy cardinality hint methodology.


Microsoft has a reccomendation where any report that times out should use the hint technology, or set the SQL instance to an older compatability mode. All of the queries in the console use this hint now if a newer version is detected.

https://docs.microsoft.com/en-US/troubleshoot/mem/configmgr/sql-query-times-out-or-console-slow-performance


This change would require a rebuild of all reports, and an update to the report installer.


  • Jordan Benzing
  • May 27 2021
  • NOTED
  • Attach files