SQL Search and SQL History show a blank screen on SSMS 22 SQL Search and SQL History show a blank screen on SSMS 22

SQL Search and SQL History show a blank screen on SSMS 22

If SQL History or SQL Search opens but shows a blank screen with nothing loading, check the SQL Search log files for the following entry:

[Error]  [RedGate.SQSearch.Addin.Utils]: Unhandled exception
System.MissingMethodException: Method not found: 'Void RedGate.SIPFramework.Services.ServicesToPlugins.SsmsFunctionalityProvider..ctor(EnvDTE80.DTE2)'.

This is usually caused by an SSMS display setting called "Optimize rendering for screens with different pixel densities". When this option is enabled, it can prevent the SQL Search and SQL History tabs from loading correctly.

To check and disable this setting:

  1. In SSMS, go to Tools > Options > All Settings
  2. Scroll down to the Visual Experience section (see the image below)
  3. If "Optimize rendering for screens with different pixel densities" is ticked, untick it
  4. Restart SSMS and try opening SQL History or SQL Search again

Was this article helpful?

0 out of 0 found this helpful

Add comment

Please sign in to leave a comment.