08 Feb 2019 19:18:28.628 [1] INFO RedGate.SQLSearch.Addin - Starting new SQLSearch 3 session 08 Feb 2019 19:18:28.637 [1] INFO RedGate.SQLSearch.Addin - Location C:\ProgramData\Red Gate\SQL Search\Active\RedGate.SQLSearch.Addin.dll 08 Feb 2019 19:18:28.638 [1] INFO RedGate.SQLSearch.Addin - Assembly version: 3.2.3.2230 08 Feb 2019 19:18:28.641 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'mscorlib' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89' 08 Feb 2019 19:18:28.644 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Platform.AppDomainManager' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.645 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89' 08 Feb 2019 19:18:28.645 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Configuration' 'V4.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.646 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Core' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89' 08 Feb 2019 19:18:28.647 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Xml' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89' 08 Feb 2019 19:18:28.647 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Windows.Forms' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89' 08 Feb 2019 19:18:28.648 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Drawing' 'V4.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.649 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.UI.Internal' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.649 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.14.0' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.650 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.Interop' 'V7.1.40304.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.650 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.OLE.Interop' 'V7.1.40304.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.651 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.Interop.8.0' 'V8.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.652 [1] INFO 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' 08 Feb 2019 19:18:28.652 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'WindowsBase' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35' 08 Feb 2019 19:18:28.653 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.Immutable.11.0' 'V11.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.654 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.Immutable.10.0' 'V10.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.654 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.Immutable.14.0' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.655 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Utilities' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.655 [1] INFO 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' 08 Feb 2019 19:18:28.656 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'PresentationFramework' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35' 08 Feb 2019 19:18:28.657 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'PresentationCore' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35' 08 Feb 2019 19:18:28.658 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Xaml' 'V4.0.0.0' key='B7-7A-5C-56-19-34-E0-89' 08 Feb 2019 19:18:28.658 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Threading' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.659 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Validation' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.660 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.Immutable.12.0' 'V12.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.660 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.ImageCatalog' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.661 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Imaging' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.661 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Platform.WindowManagement' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.662 [1] INFO 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' 08 Feb 2019 19:18:28.662 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.ViewManager' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.663 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Imaging.resources' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.663 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.GeneratedCode' 'V1.0.0.0' key='' 08 Feb 2019 19:18:28.664 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.TextManager.Interop' 'V7.1.40304.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.664 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.CommonIDE' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.665 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Diff' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.665 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'VsDebugPresentationPackage' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.666 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Debugger.Parallel' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.666 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Debugger.Parallel.resources' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.667 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Diagnostics.Assert' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.668 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Platform.WindowManagement.resources' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.668 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.UI.Internal.resources' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.669 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.AnalysisServices.Project' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.669 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.DataWarehouse.VsIntegration' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.670 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.PbmUiPackage' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.671 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.RegisteredServersUI' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.671 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.Reports' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.672 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.SqlStudio.Actions' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.673 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.SqlStudio.Explorer' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.673 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.SqlStudio' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.674 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.SqlStudio.ResourceMonitor' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.674 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.ThreatDetection' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.675 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.UpdateChecker' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.676 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.XEventUI' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.678 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'SQLEditors' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.679 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'SqlWorkbenchProject' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.680 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'RedGate.SQLSearch.SSMSPackage' 'V3.2.2.2221' key='7F-46-5A-1C-15-6D-4D-57' 08 Feb 2019 19:18:28.681 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.DataTransformationServices.VsIntegration' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.681 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'EnvDTE' 'V8.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.682 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'EnvDTE80' 'V8.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.683 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'PresentationFramework.Aero2' 'V4.0.0.0' key='31-BF-38-56-AD-36-4E-35' 08 Feb 2019 19:18:28.684 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.ExtensibilityHosting' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.684 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Telemetry.Package' 'V14.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.685 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Telemetry' 'V14.1.0.0' key='B0-3F-5F-7F-11-D5-0A-3A' 08 Feb 2019 19:18:28.686 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'SqlPackageBase' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.686 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.Controls' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.687 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.IdentityModel.Clients.ActiveDirectory' 'V3.19.8.16603' key='31-BF-38-56-AD-36-4E-35' 08 Feb 2019 19:18:28.688 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.SString' 'V14.100.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.688 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.SqlTDiagM' 'V14.100.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.689 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlTools.AppLocal.AsmResolver' 'V14.100.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.690 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Instapi' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.690 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.SDK.SqlStudio' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:28.691 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'SqlWorkbench.Interfaces' 'V14.0.0.0' key='89-84-5D-CD-80-80-CC-91' 08 Feb 2019 19:18:39.732 [1] INFO RedGate.SQLSearch.Addin.Connect - Checking updates enabled: host SSMS, version 2017.0140 08 Feb 2019 19:18:42.414 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event: [ { "eventType": "session.started", "headers": { "productId": "sql-search", "productVersion": "3.2.3.2230", "eventUuid": "8f9f6b9d-d647-4362-bf87-c0c7d305b202", "usageUserId": "2a8714cf-f05e-46e0-bc97-88a722400512", "sessionUuid": "eff488e8-debb-499f-a12a-e40c23249cda", "createdTimeUtc": "2019-02-09T03:18:40Z" }, "payload": { "hostMachine": { "software": { "operatingSystem": { "name": "Microsoft Windows 10 Pro", "is64Bit": true, "platform": "Win32NT", "servicePack": "", "compatibilityVersion": "6.2.9200.0", "kernelVersion": "10.0.17134.376" }, "dotNet": { "current": { "clrVersion": "4.0.30319.42000", "csharpVersion": "4.7.3314.0", "is64Bit": false }, "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.7.03056", "servicePack": null, "release": 461808 } }, "powerShell": { "version": "5.1.17134.1" } }, "localization": { "currentCulture": { "name": "en-US", "lcid": 1033 }, "currentUiCulture": { "name": "en-US", "lcid": 1033 }, "installedUiCulture": { "name": "en-US", "lcid": 1033 }, "localTimeZone": { "id": "Pacific Standard Time", "utcOffset": "-08:00" } }, "processInformation": { "filename": "Ssms.exe", "fileVersion": "2017.0140.17285.00 ((SSMS_Rel_17_4).180821-0238)", "productVersion": "14.0.17285.0" } }, "hardware": { "processors": [ { "numberOfLogicalProcessors": 8, "maxClockSpeedInMHz": 1992 } ], "memory": { "totalPhysicalMemoryInBytes": 17013760000, "errorCorrection": "None" }, "display": { "basicDpi": { "x": 96, "y": 96 }, "screens": [ { "isPrimary": true, "bounds": { "width": 1920, "height": 1200 } }, { "isPrimary": false, "bounds": { "width": 1920, "height": 1200 } } ] }, "virtualizationInfo": { "computerManufacturer": "HP", "computerModel": "HP Spectre x360 Convertible 13-ae0xx", "biosVersion": "HPQOEM - 1072009", "biosBIOSVersion": [ "HPQOEM - 1072009", "F.21", "American Megatrends - 5000C" ], "biosSerialNumber": "5CD8367NKM" } } } } } ] 08 Feb 2019 19:18:42.417 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 2 events: [ { "eventType": "session.started", "headers": { "productId": "sql-search", "productVersion": "3.2.3.2230", "eventUuid": "9d501898-76d3-4357-9d98-cc5ebe5d594a", "usageUserId": "20a54e99-6453-4aa7-9d1a-15756deaad85", "sessionUuid": "dcff419f-2528-4f0d-8275-d29b65ab61e9", "createdTimeUtc": "2019-02-09T03:18:40Z" }, "payload": { "hostMachine": { "software": { "operatingSystem": { "name": "Microsoft Windows 10 Pro", "is64Bit": true, "platform": "Win32NT", "servicePack": "", "compatibilityVersion": "6.2.9200.0", "kernelVersion": "10.0.17134.376", "systemDrive": "C:" }, "dotNet": { "current": { "clrVersion": "4.0.30319.42000", "csharpVersion": "4.7.3314.0", "is64Bit": false }, "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.7.03056", "servicePack": null, "release": 461808, "installPath": "C:\\Windows\\Microsoft.NET\\Framework64\\v4.0.30319\\", "is32Bit": true, "is64Bit": true } }, "powerShell": { "version": "5.1.17134.1", "executionPolicy": { "currentUser": "Undefined", "localMachine": "Undefined", "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": "Pacific Standard Time", "utcOffset": "-08:00", "displayName": "(UTC-08:00) Pacific Time (US & Canada)", "standardName": "Pacific Standard Time", "daylightName": "Pacific Daylight Time" } }, "security": { "isOnDomain": true, "isLocalAdministrator": false, "isInLocalAdministratorsGroup": true }, "processInformation": { "filename": "Ssms.exe", "fileVersion": "2017.0140.17285.00 ((SSMS_Rel_17_4).180821-0238)", "fullPath": "C:\\Program Files (x86)\\Microsoft SQL Server\\140\\Tools\\Binn\\ManagementStudio\\Ssms.exe", "productVersion": "14.0.17285.0" } }, "hardware": { "processors": [ { "numberOfLogicalProcessors": 8, "maxClockSpeedInMHz": 1992, "numberOfCores": 4, "addressWidthInBits": 64, "architecture": "x64", "caption": "Intel64 Family 6 Model 142 Stepping 10", "name": "Intel(R) Core(TM) i7-8550U CPU @ 1.80GHz" } ], "memory": { "totalPhysicalMemoryInBytes": 17013760000, "errorCorrection": "None", "memorySticks": [ { "clockSpeedInMHz": 2133, "capacityInBytes": 8589934592 }, { "clockSpeedInMHz": 2133, "capacityInBytes": 8589934592 } ] }, "disks": { "logicalDrives": [ { "name": "C:", "type": "Fixed", "availableFreeSpaceInBytes": 149863186432, "totalFreeSpaceInBytes": 149863186432, "totalSizeInBytes": 240680693760, "format": "NTFS" }, { "name": "D:", "type": "Fixed", "availableFreeSpaceInBytes": 1696804864, "totalFreeSpaceInBytes": 1696804864, "totalSizeInBytes": 14055108608, "format": "NTFS" }, { "name": "E:", "type": "Removable", "availableFreeSpaceInBytes": 101069656064, "totalFreeSpaceInBytes": 101069656064, "totalSizeInBytes": 128042659840, "format": "NTFS" }, { "name": "I:", "type": "Network", "availableFreeSpaceInBytes": 349902635008, "totalFreeSpaceInBytes": 349902635008, "totalSizeInBytes": 1099508477952, "format": "NTFS" }, { "name": "P:", "type": "Network", "availableFreeSpaceInBytes": 349902635008, "totalFreeSpaceInBytes": 349902635008, "totalSizeInBytes": 1099508477952, "format": "NTFS" } ] }, "display": { "basicDpi": { "x": 96, "y": 96 }, "screens": [ { "isPrimary": true, "bitsPerPixel": 32, "bounds": { "x": 0, "y": 0, "width": 1920, "height": 1200 }, "workingArea": { "x": 0, "y": 0, "width": 1920, "height": 1160 }, "effectiveDpi": { "x": 96, "y": 96 }, "angularDpi": { "x": 93, "y": 93 }, "rawDpi": { "x": 94, "y": 94 } }, { "isPrimary": false, "bitsPerPixel": 32, "bounds": { "x": 1920, "y": 0, "width": 1920, "height": 1200 }, "workingArea": { "x": 1920, "y": 0, "width": 1920, "height": 1160 }, "effectiveDpi": { "x": 96, "y": 96 }, "angularDpi": { "x": 93, "y": 93 }, "rawDpi": { "x": 94, "y": 94 } } ] }, "virtualizationInfo": { "computerManufacturer": "HP", "computerModel": "HP Spectre x360 Convertible 13-ae0xx", "biosVersion": "HPQOEM - 1072009", "biosBIOSVersion": [ "HPQOEM - 1072009", "F.21", "American Megatrends - 5000C" ], "biosSerialNumber": "5CD8367NKM" } } } } }, { "eventType": "honeycomb.productswitcher.initialized", "headers": { "productId": "sql-search", "productVersion": "3.2.3.2230", "eventUuid": "cbe562f5-7943-4795-aa24-4156cbec572f", "usageUserId": "20a54e99-6453-4aa7-9d1a-15756deaad85", "sessionUuid": "dcff419f-2528-4f0d-8275-d29b65ab61e9", "createdTimeUtc": "2019-02-09T03:18:40Z" }, "payload": { "currentProgram": "SqlSearch", "installedPrograms": [], "anyProductsInSwitcher": false } } ] 08 Feb 2019 19:18:43.333 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents Number of submitted usage events = 2 HTTP status code = 204 NoContent Response body = 08 Feb 2019 19:18:43.444 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://productusage.red-gate.com/v1/usageevents Number of submitted usage events = 1 HTTP status code = 204 NoContent Response body = 08 Feb 2019 19:19:02.155 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:19:06.504 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:19:09.728 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:19:26.017 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:20:28.240 [36] INFO DatabaseObjectStorage - Inserting job steps into index 08 Feb 2019 19:20:28.240 [35] INFO DatabaseObjectStorage - Inserting objects into index 08 Feb 2019 19:20:28.319 [36] ERROR ServerObjectIndexer - Exception while indexing server: System.Data.SqlClient.SqlException (0x80131904): The SELECT permission was denied on the object 'sysjobsteps', database 'msdb', schema 'dbo'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at RedGate.SQLSearch.Indexing.SQLServer.SqlServerConnection.d__2.MoveNext() at RedGate.SQLSearch.Indexing.SQLServer.SqlServerReader.d__6.MoveNext() at RedGate.SQLSearch.Indexing.SQLite.ServerObjectStorage.InsertJobSteps(IEnumerable`1 ) at RedGate.SQLSearch.Indexing.ServerObjectIndexer.Index(ISqlServerReader , IServerObjectStorage ) at RedGate.SQLSearch.Indexing.ServerObjectIndexer.Index() ClientConnectionId:528d939f-1a3c-4f63-8a1e-49ec6f66e774 Error Number:229,State:5,Class:14 08 Feb 2019 19:20:28.632 [35] INFO DatabaseObjectStorage - Done objects 08 Feb 2019 19:20:28.633 [35] INFO DatabaseObjectStorage - Inserting columns into index 08 Feb 2019 19:20:28.828 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:20:29.568 [35] INFO DatabaseObjectStorage - Done columns 08 Feb 2019 19:20:29.571 [35] INFO DatabaseObjectStorage - Inserting objects into index 08 Feb 2019 19:20:29.728 [35] INFO DatabaseObjectStorage - Done objects 08 Feb 2019 19:20:29.731 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event: [ { "eventType": "index.objects", "headers": { "productId": "sql-search", "productVersion": "3.2.3.2230", "eventUuid": "ee7b3c8c-6217-41d9-b774-cf0b68b20d44", "usageUserId": "20a54e99-6453-4aa7-9d1a-15756deaad85", "sessionUuid": "dcff419f-2528-4f0d-8275-d29b65ab61e9", "createdTimeUtc": "2019-02-09T03:20:29Z" }, "payload": { "index-type": "full", "time-taken": "1490", "objects-updated": "7613" } } ] 08 Feb 2019 19:20:30.550 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents Number of submitted usage events = 1 HTTP status code = 204 NoContent Response body = 08 Feb 2019 19:22:58.109 [9] INFO DatabaseObjectStorage - Inserting job steps into index 08 Feb 2019 19:22:58.178 [9] ERROR ServerObjectIndexer - Exception while indexing server: System.Data.SqlClient.SqlException (0x80131904): The SELECT permission was denied on the object 'sysjobsteps', database 'msdb', schema 'dbo'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at RedGate.SQLSearch.Indexing.SQLServer.SqlServerConnection.d__2.MoveNext() at RedGate.SQLSearch.Indexing.SQLServer.SqlServerReader.d__6.MoveNext() at RedGate.SQLSearch.Indexing.SQLite.ServerObjectStorage.InsertJobSteps(IEnumerable`1 ) at RedGate.SQLSearch.Indexing.ServerObjectIndexer.Index(ISqlServerReader , IServerObjectStorage ) at RedGate.SQLSearch.Indexing.ServerObjectIndexer.Index() ClientConnectionId:e564f14a-a75b-4453-988a-eb00fe16df66 Error Number:229,State:5,Class:14 08 Feb 2019 19:22:58.205 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event: [ { "eventType": "search", "headers": { "productId": "sql-search", "productVersion": "3.2.3.2230", "eventUuid": "fe8852f6-fe66-4c1d-b142-4eb0660baffb", "usageUserId": "2a8714cf-f05e-46e0-bc97-88a722400512", "sessionUuid": "eff488e8-debb-499f-a12a-e40c23249cda", "createdTimeUtc": "2019-02-09T03:22:58Z" }, "payload": null } ] 08 Feb 2019 19:22:58.205 [11] ERROR RedGate.SQSearch.Addin.Utils - Unhandled exception System.Exception: Cannot notify of usage event while sleeping at RedGate.SQLSearch.UsageReporting.Events.SleepingUsageEvent.NotifyReport() at RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper.ReportProductUsage(IUsageEvent usageEvent) at RedGate.SQLSearch.Addin.Tab.Searcher.Search(ICollection`1 indexerRunners) at RedGate.SQLSearch.Addin.Tab.Searcher.DoSearch(ICollection`1 indexerRunners) at RedGate.SQLSearch.Addin.Tab.Searcher.<>c__DisplayClass15_0.b__3() at RedGate.SQLSearch.Addin.Utils.ErrorDialog.<>c__DisplayClass25_0.b__0(EventArgs ) at RedGate.SQLSearch.Addin.Utils.ErrorDialog.DoWithErrorHandling(ILog log, IWin32Window parentWindow, InvokerDelegate`1 toDo, EventArgs args) 08 Feb 2019 19:22:58.205 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event: [ { "eventType": "search", "headers": { "productId": "sql-search", "productVersion": "3.2.3.2230", "eventUuid": "4e91b552-e0a7-4130-bcc8-006f640b51dc", "usageUserId": "20a54e99-6453-4aa7-9d1a-15756deaad85", "sessionUuid": "dcff419f-2528-4f0d-8275-d29b65ab61e9", "createdTimeUtc": "2019-02-09T03:22:58Z" }, "payload": { "searched-databases": "multiple", "search-string-length": "4" } } ] 08 Feb 2019 19:22:59.021 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://productusage.red-gate.com/v1/usageevents Number of submitted usage events = 1 HTTP status code = 204 NoContent Response body = 08 Feb 2019 19:22:59.037 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents Number of submitted usage events = 1 HTTP status code = 204 NoContent Response body = 08 Feb 2019 19:22:59.186 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:23:00.186 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:23:00.478 [41] INFO DatabaseObjectStorage - Inserting job steps into index 08 Feb 2019 19:23:00.547 [41] ERROR ServerObjectIndexer - Exception while indexing server: System.Data.SqlClient.SqlException (0x80131904): The SELECT permission was denied on the object 'sysjobsteps', database 'msdb', schema 'dbo'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at RedGate.SQLSearch.Indexing.SQLServer.SqlServerConnection.d__2.MoveNext() at RedGate.SQLSearch.Indexing.SQLServer.SqlServerReader.d__6.MoveNext() at RedGate.SQLSearch.Indexing.SQLite.ServerObjectStorage.InsertJobSteps(IEnumerable`1 ) at RedGate.SQLSearch.Indexing.ServerObjectIndexer.Index(ISqlServerReader , IServerObjectStorage ) at RedGate.SQLSearch.Indexing.ServerObjectIndexer.Index() ClientConnectionId:f2ccab98-d01f-4df5-980c-026808a903ab Error Number:229,State:5,Class:14 08 Feb 2019 19:23:03.533 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:23:05.940 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:25:38.777 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event: [ { "eventType": "search", "headers": { "productId": "sql-search", "productVersion": "3.2.3.2230", "eventUuid": "6abd6628-db2b-4ef3-bbb9-cbfad668314c", "usageUserId": "20a54e99-6453-4aa7-9d1a-15756deaad85", "sessionUuid": "dcff419f-2528-4f0d-8275-d29b65ab61e9", "createdTimeUtc": "2019-02-09T03:25:38Z" }, "payload": { "searched-databases": "multiple", "search-string-length": "8" } } ] 08 Feb 2019 19:25:39.753 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:25:39.763 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents Number of submitted usage events = 1 HTTP status code = 204 NoContent Response body = 08 Feb 2019 19:25:41.381 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:25:42.699 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:26:17.378 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:26:23.321 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:26:29.096 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 19:26:49.482 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event: [ { "eventType": "search", "headers": { "productId": "sql-search", "productVersion": "3.2.3.2230", "eventUuid": "7d127918-86ca-4751-b05c-6f328530f942", "usageUserId": "20a54e99-6453-4aa7-9d1a-15756deaad85", "sessionUuid": "dcff419f-2528-4f0d-8275-d29b65ab61e9", "createdTimeUtc": "2019-02-09T03:26:49Z" }, "payload": { "searched-databases": "multiple", "search-string-length": "11" } } ] 08 Feb 2019 19:26:50.219 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents Number of submitted usage events = 1 HTTP status code = 204 NoContent Response body = 08 Feb 2019 19:26:51.343 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler) 08 Feb 2019 21:43:00.158 [157] INFO DatabaseObjectStorage - Inserting objects into index 08 Feb 2019 21:43:00.493 [157] INFO DatabaseObjectStorage - Done objects 08 Feb 2019 21:43:00.494 [157] INFO DatabaseObjectStorage - Inserting columns into index 08 Feb 2019 21:43:01.438 [157] INFO DatabaseObjectStorage - Done columns 08 Feb 2019 21:43:01.439 [157] INFO DatabaseObjectStorage - Inserting objects into index 08 Feb 2019 21:43:01.624 [157] INFO DatabaseObjectStorage - Done objects 08 Feb 2019 21:43:01.625 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event: [ { "eventType": "index.objects", "headers": { "productId": "sql-search", "productVersion": "3.2.3.2230", "eventUuid": "c1e80de0-3e69-48de-8cdb-ca057c0e6dd0", "usageUserId": "20a54e99-6453-4aa7-9d1a-15756deaad85", "sessionUuid": "dcff419f-2528-4f0d-8275-d29b65ab61e9", "createdTimeUtc": "2019-02-09T05:43:01Z" }, "payload": { "index-type": "full", "time-taken": "1466", "objects-updated": "7613" } } ] 08 Feb 2019 21:43:01.629 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event: [ { "eventType": "search", "headers": { "productId": "sql-search", "productVersion": "3.2.3.2230", "eventUuid": "4a284753-de75-4c67-a1ec-5e58fac49b9a", "usageUserId": "2a8714cf-f05e-46e0-bc97-88a722400512", "sessionUuid": "eff488e8-debb-499f-a12a-e40c23249cda", "createdTimeUtc": "2019-02-09T05:43:01Z" }, "payload": null } ] 08 Feb 2019 21:43:02.510 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://productusage.red-gate.com/v1/usageevents Number of submitted usage events = 1 HTTP status code = 204 NoContent Response body = 08 Feb 2019 21:43:02.522 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents Number of submitted usage events = 1 HTTP status code = 204 NoContent Response body = 08 Feb 2019 21:43:02.523 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Sending 1 event: [ { "eventType": "search", "headers": { "productId": "sql-search", "productVersion": "3.2.3.2230", "eventUuid": "3d8790eb-66ac-442d-abb7-ac71bae3bc2b", "usageUserId": "20a54e99-6453-4aa7-9d1a-15756deaad85", "sessionUuid": "dcff419f-2528-4f0d-8275-d29b65ab61e9", "createdTimeUtc": "2019-02-09T05:43:01Z" }, "payload": { "searched-databases": "multiple", "search-string-length": "11" } } ] 08 Feb 2019 21:43:02.766 [Redgate.Usage.AsynchronousUsageApiClient] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - Usage reporting request made to https://featureusage.red-gate.com/v1/usageevents Number of submitted usage events = 1 HTTP status code = 204 NoContent Response body = 08 Feb 2019 21:43:04.917 [1] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Failed to get the object hierarchy Exception: Exception has been thrown by the target of an invocation. at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer.RootNode(String connectionString, IErrorHandler errorHandler)