How can we help you today? How can we help you today?
bianca
Activity overview Badges (0) Posts (1) Comments (3)

Activity overview

Latest activity by bianca

Hi, Dan. Sorry to reply so late. I've used the Revo Uninstaller to uninstall SQL Prompt and removed any leftover files. There were some registry keys that were left behind. It works again now. Thank you very much for your help. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt has stopped working in SSMS v18.9
Hi, Dan. Sorry to reply so late. I've used the Revo Uninstaller to uninstall SQL Prompt and removed any leftover files. There were some registry keys that were left behind. It works again now. Than...
0 votes
Hi, Dan. Thank you for trying to help. The Show Log and Enable Verbose logging seem completely disabled for me in SSMS. I was able to get to the log files however.  This is what I can see in one of the most recent log files: 2021-05-13 20:54:17.145 +01:00 [Information] Launching package entry point Ssms18 (version 15.0.18384.0) for SQL Prompt 10.6.10.19533. 2021-05-13 20:54:17.253 +01:00 [Information] Starting new SQL Prompt 10.6.10.19533 editor session 2021-05-13 20:54:18.299 +01:00 [Information] BaseConnect(RedGate.SQLPrompt.SsmsPackage18.ConnectAdapter) constructed successfully 2021-05-13 20:54:18.505 +01:00 [Information] Initialising DTE and AddIn connections. *** DTE.FullName = C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe, DTE.Version = 2019.0150, DTE.CommandLine = , *** AddIn.Name = SQL Prompt, AddIn.ProgID = RedGate.SQLPrompt.Package, AddIn.Description = SQL Prompt 2021-05-13 20:54:18.506 +01:00 [Information] Current culture en-US 2021-05-13 20:54:18.506 +01:00 [Information] AddIn.SatelliteDllPath = null 2021-05-13 20:54:18.959 +01:00 [Error] Report error dialog UI shown System.NullReferenceException: Object reference not set to an instance of an object.    at Format.Engine.Styles.Saving.StyleFilePathGenerator.GetFilePath(FormattingStyle style)    at Format.Engine.Styles.Upgrading.StyleFileNamesUpgrader.<Upgrade>d__5.MoveNext()    at Format.Engine.Styles.Upgrading.StylesUpgrader.Upgrade()    at RedGate.SQLPrompt.CommonVS.BaseConnect.UpgradeFormattingStyles()    at RedGate.SQLPrompt.CommonVS.BaseConnect.Initialize(DTE2 dte, AddIn addInInstance)    at RedGate.SQLPrompt.SSMSUI.AbstractSsmsConnect.Initialize(DTE2 dte, AddIn addInInstance)    at RedGate.SQLPrompt.SSMSUI.AbstractSsmsConnect.VsPackageInitialize(DTE dte)    at RedGate.SQLPrompt.SsmsPackage18.SQLPromptSsmsPackage18.<>c__DisplayClass1_0.<Initialize>b__0()    at RedGate.SQLPrompt.UsageReporting.ErrorReporting.ErrorReporterWithUI.Do(Action action) This doesn't seem to have a lot of detail but in another earlier log file I can see more info: 2021-04-09 13:13:31.564 +01:00 [Information] Launching package entry point Ssms18 (version 15.0.18338.0) for SQL Prompt 10.6.6.18829. 2021-04-09 13:13:31.731 +01:00 [Information] Starting new SQL Prompt 10.6.6.18829 editor session 2021-04-09 13:13:32.645 +01:00 [Information] BaseConnect(RedGate.SQLPrompt.SsmsPackage18.ConnectAdapter) constructed successfully 2021-04-09 13:13:32.928 +01:00 [Information] Initialising DTE and AddIn connections. *** DTE.FullName = C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe, DTE.Version = 2019.0150, DTE.CommandLine = , *** AddIn.Name = SQL Prompt, AddIn.ProgID = RedGate.SQLPrompt.Package, AddIn.Description = SQL Prompt 2021-04-09 13:13:32.928 +01:00 [Information] Current culture en-US 2021-04-09 13:13:32.928 +01:00 [Information] AddIn.SatelliteDllPath = null 2021-04-09 13:13:33.343 +01:00 [Error] Report error dialog UI shown System.NullReferenceException: Object reference not set to an instance of an object.    at Format.Engine.Styles.Saving.StyleFilePathGenerator.GetFilePath(FormattingStyle style)    at Format.Engine.Styles.Upgrading.StyleFileNamesUpgrader.<Upgrade>d__5.MoveNext()    at Format.Engine.Styles.Upgrading.StylesUpgrader.Upgrade()    at RedGate.SQLPrompt.CommonVS.BaseConnect.UpgradeFormattingStyles()    at RedGate.SQLPrompt.CommonVS.BaseConnect.Initialize(DTE2 dte, AddIn addInInstance)    at RedGate.SQLPrompt.SsmsPackage18.ConnectAdapter.Initialize(DTE2 dte, AddIn addInInstance)    at RedGate.SQLPrompt.SsmsPackage18.ConnectAdapter.VsPackageInitialize(DTE dte)    at RedGate.SQLPrompt.SsmsPackage18.SQLPromptSsmsPackage18.<>c__DisplayClass1_0.<Initialize>b__0()    at RedGate.SQLPrompt.UsageReporting.ErrorReporting.ErrorReporterWithUI.Do(Action action) 2021-04-09 13:13:38.800 +01:00 [Error] Error during collection of environmental data for usage reporting System.IO.FileNotFoundException: Could not load file or assembly 'System.CodeDom, Version=5.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified. File name: 'System.CodeDom, Version=5.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'    at RedGate.Usage.Client.Payload.SessionStarted.DotNetCurrentDataSource.GetCSharpVersion()    at RedGate.Usage.Client.Payload.PayloadDataSourceBase.GetDataSafely[T](Func`1 getData) WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. 2021-04-09 13:13:38.902 +01:00 [Error] Error during collection of environmental data for usage reporting System.IO.FileNotFoundException: Could not load file or assembly 'System.Security.Principal.Windows, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified. File name: 'System.Security.Principal.Windows, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'    at RedGate.Usage.Client.Payload.SessionStarted.Windows.SecurityDataSource.GetTokenElevationType()    at RedGate.Usage.Client.Payload.PayloadDataSourceBase.GetDataSafely[T](Func`1 getData, T errorValue) WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog]. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt has stopped working in SSMS v18.9
Hi, Dan. Thank you for trying to help. The Show Log and Enable Verbose logging seem completely disabled for me in SSMS. I was able to get to the log files however. This is what I can see in one of ...
0 votes
Hi, Victoria. Thank you for getting in touch. I've submitted an error report just now. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt has stopped working in SSMS v18.9
Hi, Victoria. Thank you for getting in touch. I've submitted an error report just now.
0 votes
SQL Prompt has stopped working in SSMS v18.9
  1. Community
  2. SQL Prompt
Hello,I've recently upgraded my SSMS to the most recent version (18.9.1) and I've noticed that SQL Prompt doesn't seem to work anymore. Whenever I open SSMS, I get this error: "Object reference not...
5 followers 10 comments 0 votes
Total activity
5
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1