How can we help you today? How can we help you today?

SSMS 18.2 crashes after connection to SQL Server after installation of SQL Search 3.6

Hi,

I have SSMS v18.2 (it's installed on a server of a customer, therefore the version can't be upgraded easily, the component version in the About screen is 15.0.18142.0) and I would like to use SQL Search for troubleshooting. But it seems impossible to use it with this version.

When I install SQL Search 3.6.16.4399 it's fine as long as I don't open a connection. If i do, it looks fine for a second and then tree is loading, but then SSMS crashes. If I deinstall SQL Search (via “Add or remove programs”) SSMS is working again without problemes.

What can I do to get SQL Search runnging?

 

BR, Friedrich

friedrich.eberharter
0

Comments

3 comments

  • Vic
    Official comment

    Hi friedrich.eberharter 

    Are you able to provide the SQL Search log files so that we can see what's happening?

    https://documentation.red-gate.com/ss/troubleshooting/logging-and-log-files

    If you don't want to attach them to this post, please send them to support@red-gate.com referencing ticket no. 333034.

    Vic
  • friedrich.eberharter

    Hello Vic,

    thank you for getting back on this!

    Yes, I can share the log file as i can't see any hyper sensitive data in it. The menu of SQL Search is not the same as in your link: It seems like logging was already active but I'm not able to set the log level.

    So I can show you this log file but I'm not sure with what level it was created:

    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'mscorlib' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Platform.AppDomainManager' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'System' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'System.Windows.Forms' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'System.Drawing' 'V4.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'CrowdStrike.Sensor.ScriptControl' 'V7.21.19209.0' key='02-B6-09-67-B1-F6-81-87'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Shell.UI.Internal' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Shell.15.0' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Shell.Interop' 'V7.1.40304.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.OLE.Interop' 'V7.1.40304.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Shell.Interop.8.0' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Shell.Interop.9.0' 'V9.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Shell.Framework' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'System.Core' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'WindowsBase' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'System.Configuration' 'V4.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'System.Xml' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Utilities' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Threading' 'V15.8.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Validation' 'V15.3.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Shell.Interop.10.0' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'PresentationFramework' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'PresentationCore' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'System.Xaml' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Telemetry.Package' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Telemetry' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Utilities.Internal' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.ImageCatalog' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Imaging' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Platform.WindowManagement' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Shell.Interop.11.0' 'V11.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Shell.ViewManager' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Imaging.resources' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.GeneratedCode' 'V1.0.0.0' key=''
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Diagnostics.Assert' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.TextManager.Interop' 'V7.1.40304.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.CommonIDE' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Diff' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Editors.WCF' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.ErrorListPkg' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Workspace.VSIntegration' 'V15.0.0.0' key=''
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.ReferenceManager.Providers' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.ReferenceManager.Providers.resources' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.DataTransformationServices.VsIntegration' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Editor.Implementation' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Platform.WindowManagement.resources' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.VisualStudio.Shell.UI.Internal.resources' 'V15.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.AnalysisServices.Project' 'V15.4.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.DataWarehouse.VsIntegration' 'V15.4.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.Management.PbmUiPackage' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.Management.RegisteredServersUI' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.Management.Reports' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.Management.SqlStudio.Actions' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.Management.SqlStudio.Explorer' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.Management.SqlStudio' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.Management.SqlStudio.ResourceMonitor' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.Management.ThreatDetection' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.Management.UpdateChecker' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.Management.XEventUI' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'SQLEditors' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'SqlWorkbenchProject' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'RedGate.SQLSearch.SSMSPackage18' 'V3.6.16.4399' key='7F-46-5A-1C-15-6D-4D-57'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'EnvDTE' 'V8.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'EnvDTE80' 'V8.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'PresentationFramework.Aero2' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'UIAutomationTypes' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'UIAutomationProvider' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'SqlPackageBase' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.Management.Controls' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory' 'V3.19.8.16603' key='31-BF-38-56-AD-36-4E-35'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.SString' 'V15.100.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.SqlTDiagM' 'V15.100.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlTools.AppLocal.AsmResolver' 'V15.100.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'System.Design' 'V4.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.Management.SDK.SqlStudio' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'Microsoft.SqlServer.RegSvrEnum' 'V15.100.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:34:53.920 -05:00 [Information]  [RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer]: Assembly 'SqlWorkbench.Interfaces' 'V15.0.0.0' key='89-84-5D-CD-80-80-CC-91'
    2025-05-22 08:35:04.590 -05:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: The reporting of usage events to the product stream is enabled
    2025-05-22 08:35:04.605 -05:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: The reporting of usage events to the feature stream is enabled
    2025-05-22 08:35:07.856 -05:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: Sending 3 events:
    [
     {
       "eventType": "session.started",
       "headers": {
         "productId": "sql-search",
         "productVersion": "3.6.16.4399",
         "eventUuid": "b94d7dc0-7752-4b95-a299-866bb76eb3ab",
         "usageUserId": "f2e42050-0f82-4524-9c6f-4f44ac2f8e08",
         "sessionUuid": "de9a7da2-499f-41b2-914d-ffdb2201e41a",
         "createdTimeUtc": "2025-05-22T13:35:04Z"
       },
       "payload": {
         "hostMachine": {
           "hardware": {
             "disks": {
               "logicalDrives": [
                 {
                   "name": "C:",
                   "type": "Fixed",
                   "availableFreeSpaceInBytes": 88046829568,
                   "totalFreeSpaceInBytes": 88046829568,
                   "totalSizeInBytes": 161061273600,
                   "format": "NTFS"
                 },
                 {
                   "name": "E:",
                   "type": "Fixed",
                   "availableFreeSpaceInBytes": 41875931136,
                   "totalFreeSpaceInBytes": 41875931136,
                   "totalSizeInBytes": 42949672960,
                   "format": "NTFS"
                 },
                 {
                   "name": "G:",
                   "type": "Fixed",
                   "availableFreeSpaceInBytes": 41875931136,
                   "totalFreeSpaceInBytes": 41875931136,
                   "totalSizeInBytes": 42949672960,
                   "format": "NTFS"
                 },
                 {
                   "name": "H:",
                   "type": "Fixed",
                   "availableFreeSpaceInBytes": 11811160064,
                   "totalFreeSpaceInBytes": 11811160064,
                   "totalSizeInBytes": 42949672960,
                   "format": "NTFS"
                 }
               ]
             },
             "display": {
               "highContrast": false,
               "basicDpi": {
                 "x": 96,
                 "y": 96
               },
               "screens": [
                 {
                   "isPrimary": true,
                   "bitsPerPixel": 32,
                   "bounds": {
                     "x": 0,
                     "y": 0,
                     "width": 1920,
                     "height": 1104
                   },
                   "workingArea": {
                     "x": 0,
                     "y": 0,
                     "width": 1920,
                     "height": 1064
                   },
                   "effectiveDpi": {
                     "x": 96,
                     "y": 96
                   },
                   "angularDpi": {
                     "x": 96,
                     "y": 96
                   },
                   "rawDpi": {
                     "x": 96,
                     "y": 96
                   }
                 }
               ]
             },
             "memory": {
               "totalPhysicalMemoryInBytes": 17179332608,
               "errorCorrection": "None"
             },
             "processors": [
               {
                 "numberOfLogicalProcessors": 2,
                 "maxClockSpeedInMHz": 2594,
                 "numberOfCores": 2,
                 "addressWidthInBits": 64,
                 "architecture": "x64",
                 "caption": "Intel64 Family 6 Model 106 Stepping 6",
                 "name": "Intel(R) Xeon(R) Gold 6348 CPU @ 2.60GHz"
               }
             ]
           },
           "software": {
             "dotNet": {
               "current": {
                 "clrVersion": "4.0.30319.42000",
                 "csharpVersion": "4.8.4770.0",
                 "frameworkDescription": ".NET Framework 4.8.4775.0",
                 "is64Bit": false,
                 "isLinux": false,
                 "isOsx": false,
                 "isWindows": true,
                 "osArchitecture": "X64",
                 "osDescription": "Microsoft Windows 10.0.14393 ",
                 "processArchitecture": "X86"
               },
               "frameworks": {
                 "2.0": {
                   "isInstalled": true,
                   "version": "2.0.50727.4927",
                   "servicePack": 2,
                   "release": null,
                   "installPath": "C:\\Windows\\Microsoft.NET\\Framework64\\v2.0.50727",
                   "is32Bit": true,
                   "is64Bit": true
                 },
                 "3.0": {
                   "isInstalled": true,
                   "version": "3.0.30729.4926",
                   "servicePack": 2,
                   "release": null,
                   "installPath": "C:\\Windows\\Microsoft.NET\\Framework64\\v3.0",
                   "is32Bit": true,
                   "is64Bit": true
                 },
                 "3.5": {
                   "isInstalled": true,
                   "version": "3.5.30729.4926",
                   "servicePack": 1,
                   "release": null,
                   "installPath": "C:\\Windows\\Microsoft.NET\\Framework64\\v3.5\\",
                   "is32Bit": true,
                   "is64Bit": true
                 },
                 "4.0": {
                   "isInstalled": true,
                   "version": "4.8.03761",
                   "servicePack": null,
                   "release": 528049,
                   "installPath": "C:\\Windows\\Microsoft.NET\\Framework64\\v4.0.30319\\",
                   "is32Bit": true,
                   "is64Bit": true
                 }
               },
               "powerShell": {
                 "version": "5.1.14393.7155",
                 "executionPolicy": {
                   "currentUser": "Undefined",
                   "localMachine": "Bypass",
                   "userPolicy": "Undefined",
                   "machinePolicy": "Undefined"
                 }
               }
             },
             "localization": {
               "currentCulture": {
                 "name": "en-US",
                 "lcid": 1033,
                 "nativeName": "English (United States)",
                 "englishName": "English (United States)",
                 "isoLanguageName": "eng"
               },
               "currentUiCulture": {
                 "name": "en-US",
                 "lcid": 1033,
                 "nativeName": "English (United States)",
                 "englishName": "English (United States)",
                 "isoLanguageName": "eng"
               },
               "installedUiCulture": {
                 "name": "en-US",
                 "lcid": 1033,
                 "nativeName": "English (United States)",
                 "englishName": "English (United States)",
                 "isoLanguageName": "eng"
               },
               "localTimeZone": {
                 "id": "Central Standard Time",
                 "utcOffset": "05:00",
                 "displayName": "(UTC-06:00) Central Time (US & Canada)",
                 "standardName": "Central Standard Time",
                 "daylightName": "Central Daylight Time"
               }
             },
             "operatingSystem": {
               "is64Bit": true,
               "kernelVersion": "10.0.14393.6343",
               "name": "Microsoft Windows Server 2016 Standard",
               "platform": "Win32NT",
               "servicePack": "",
               "compatibilityVersion": "10.0.14393.0",
               "systemDrive": "C:"
             },
             "processInformation": {
               "filename": "Ssms.exe",
               "fileVersion": "2019.0150.18142.00 ((SSMS_Rel).190722-0816)",
               "fullPath": "C:\\Program Files (x86)\\Microsoft SQL Server Management Studio 18\\Common7\\IDE\\Ssms.exe",
               "productVersion": "15.0.18142.0"
             },
             "security": {
               "isOnDomain": true,
               "isLocalAdministrator": false,
               "isInLocalAdministratorsGroup": true
             }
           }
         }
       }
     },
     {
       "eventType": "honeycomb.productswitcher.initialized",
       "headers": {
         "productId": "sql-search",
         "productVersion": "3.6.16.4399",
         "eventUuid": "c62b023d-8c2c-4219-8fa6-33602c87fb9d",
         "usageUserId": "f2e42050-0f82-4524-9c6f-4f44ac2f8e08",
         "sessionUuid": "de9a7da2-499f-41b2-914d-ffdb2201e41a",
         "createdTimeUtc": "2025-05-22T13:35:04Z"
       },
       "payload": {
         "currentProgram": "SqlSearch",
         "installedPrograms": [],
         "anyProductsInSwitcher": false
       }
     },
     {
       "eventType": "installed.products",
       "headers": {
         "productId": "sql-search",
         "productVersion": "3.6.16.4399",
         "eventUuid": "31c7df27-36fd-47f0-a971-301cbb29e144",
         "usageUserId": "f2e42050-0f82-4524-9c6f-4f44ac2f8e08",
         "sessionUuid": "de9a7da2-499f-41b2-914d-ffdb2201e41a",
         "createdTimeUtc": "2025-05-22T13:35:04Z"
       },
       "payload": {
         "prompt.installed": "False",
         "dependency.tracker.installed": "False",
         "doc.installed": "False",
         "test.installed": "False",
         "data.generator.installed": "False",
         "multi.script.installed": "False",
         "source.control.installed": "False",
         "compare.installed": "False",
         "data.compare.installed": "False"
       }
     }
    ]
    2025-05-22 08:35:07.856 -05:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: Sending 2 events:
    [
     {
       "eventType": "session.started",
       "headers": {
         "productId": "sql-search",
         "productVersion": "3.6.16.4399",
         "eventUuid": "eef1c4f9-9cb0-4e33-a973-5e19d4d67bdf",
         "usageUserId": "5b5f9ff1-c036-4e44-8537-025e53df6c72",
         "sessionUuid": "d3a1a0fd-7b57-4911-a2f9-1f48e624b8ba",
         "createdTimeUtc": "2025-05-22T13:35:04Z"
       },
       "payload": {
         "hostMachine": {
           "hardware": {
             "display": {
               "highContrast": false,
               "basicDpi": {
                 "x": 96,
                 "y": 96
               },
               "screens": [
                 {
                   "isPrimary": true,
                   "bounds": {
                     "width": 1920,
                     "height": 1104
                   }
                 }
               ]
             },
             "memory": {
               "totalPhysicalMemoryInBytes": 17179332608,
               "errorCorrection": "None"
             },
             "processors": [
               {
                 "numberOfLogicalProcessors": 2,
                 "maxClockSpeedInMHz": 2594
               }
             ]
           },
           "software": {
             "dotNet": {
               "current": {
                 "clrVersion": "4.0.30319.42000",
                 "csharpVersion": "4.8.4770.0",
                 "frameworkDescription": ".NET Framework 4.8.4775.0",
                 "is64Bit": false,
                 "isLinux": false,
                 "isOsx": false,
                 "isWindows": true
               },
               "frameworks": {
                 "2.0": {
                   "isInstalled": true,
                   "version": "2.0.50727.4927",
                   "servicePack": 2,
                   "release": null
                 },
                 "3.0": {
                   "isInstalled": true,
                   "version": "3.0.30729.4926",
                   "servicePack": 2,
                   "release": null
                 },
                 "3.5": {
                   "isInstalled": true,
                   "version": "3.5.30729.4926",
                   "servicePack": 1,
                   "release": null
                 },
                 "4.0": {
                   "isInstalled": true,
                   "version": "4.8.03761",
                   "servicePack": null,
                   "release": 528049
                 }
               },
               "powerShell": {
                 "version": "5.1.14393.7155"
               }
             },
             "localization": {
               "currentCulture": {
                 "name": "en-US",
                 "lcid": 1033
               },
               "currentUiCulture": {
                 "name": "en-US",
                 "lcid": 1033
               },
               "installedUiCulture": {
                 "name": "en-US",
                 "lcid": 1033
               },
               "localTimeZone": {
                 "id": "Central Standard Time",
                 "utcOffset": "05:00"
               }
             },
             "operatingSystem": {
               "is64Bit": true,
               "kernelVersion": "10.0.14393.6343",
               "name": "Microsoft Windows Server 2016 Standard",
               "platform": "Win32NT",
               "servicePack": "",
               "compatibilityVersion": "10.0.14393.0"
             },
             "processInformation": {
               "filename": "Ssms.exe",
               "fileVersion": "2019.0150.18142.00 ((SSMS_Rel).190722-0816)",
               "productVersion": "15.0.18142.0"
             }
           }
         }
       }
     },
     {
       "eventType": "search.started",
       "headers": {
         "productId": "sql-search",
         "productVersion": "3.6.16.4399",
         "eventUuid": "31c202ad-fc0a-4b43-a5f2-ca6af2f38ab7",
         "usageUserId": "5b5f9ff1-c036-4e44-8537-025e53df6c72",
         "sessionUuid": "d3a1a0fd-7b57-4911-a2f9-1f48e624b8ba",
         "createdTimeUtc": "2025-05-22T13:35:04Z"
       },
       "payload": null
     }
    ]
    2025-05-22 08:35:08.793 -05:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: Usage reporting request made to https://productusage.red-gate.com/v1/usageevents
     Number of submitted usage events = 2
     HTTP status code = 200 OK
     Response body =
    2025-05-22 08:35:08.825 -05:00 [Information]  [RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper]: Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents
     Number of submitted usage events = 3
     HTTP status code = 200 OK
     Response body =
     

    friedrich.eberharter
    0
  • Vic

    Hi friedrich.eberharter 

    I've just checked the SQL Search requirements and I'm afraid it doesn't support SSMS versions 18.0 - 18.4:

    https://documentation.red-gate.com/ss/requirements

    Vic
    0

Add comment

Please sign in to leave a comment.