Comments
3 comments
-
Official commentAre 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.
-
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 =
-
I've just checked the SQL Search requirements and I'm afraid it doesn't support SSMS versions 18.0 - 18.4:
Add comment
Please sign in to leave a comment.
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