How can we help you today? How can we help you today?
TheoL
Activity overview Badges (0) Posts (4) Comments (13)

Activity overview

Latest activity by TheoL

@Sujay For those still affected by this issue, could you please include the link to download SQL Prompt version 10.4.7. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 10.5.x not loading in Visual Studio 2017/2019
@Sujay For those still affected by this issue, could you please include the link to download SQL Prompt version 10.4.7.
0 votes
Just tested SQL Prompt 10.6.2. Result: Visual Studio 2017: Error still present  Visual Studio 2019: Appears to load OK - at least enough to appear in the menu. Did not test further before reverting back  to version 10.4.7 These tests are done on the same computer. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 10.5.x not loading in Visual Studio 2017/2019
Just tested SQL Prompt 10.6.2.Result: Visual Studio 2017: Error still present Visual Studio 2019: Appears to load OK - at least enough to appear in the menu. Did not test further before reverting b...
0 votes
SQL Prompt 10.5.6.17542 still has not resolved the issue  [image] / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 10.5.x not loading in Visual Studio 2017/2019
SQL Prompt 10.5.6.17542 still has not resolved the issue 
0 votes
Thanks for the update. I tried this, but no change. Not noted before, the SQL Prompt main menu item fails to show when opening any SQL file.  I tested on Visual Studio 2017 Enterprise 15.9.30. The full error message from ActivityLog.xml: Begin package load [SQLPromptPackage] SetSite failed for package [SQLPromptPackage]Source: 'RedGate.SQLPrompt.UsageReporting' Description: The type initializer for 'Microsoft.ApplicationInsights.Extensibility.TelemetryConfiguration' threw an exception. System.TypeInitializationException: The type initializer for 'Microsoft.ApplicationInsights.Extensibility.TelemetryConfiguration' threw an exception. ---> System.TypeLoadException: Could not load type 'System.Diagnostics.Activity' from assembly 'System.Diagnostics.DiagnosticSource, Version=4.0.1.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. at Microsoft.ApplicationInsights.Extensibility.TelemetryConfiguration.<>c.<.cctor>b__13_0() at Microsoft.ApplicationInsights.ActivityExtensions.TryRun(Action action) at Microsoft.ApplicationInsights.Extensibility.TelemetryConfiguration..cctor() --- End of inner exception stack trace --- at RedGate.SQLPrompt.UsageReporting.AppInsightsClient.GetClient() at RedGate.SQLPrompt.UsageReporting.AppInsightsClient.get_Client() at RedGate.SQLPrompt.UsageReporting.ErrorReporting.ErrorReporter.CreateExceptionReporterController(Exception e, Boolean doRateLimit, Boolean shownToUser, Boolean includeUsersEmailAddress) at RedGate.SQLPrompt.UsageReporting.ErrorReporting.ErrorReporter.ShowError(Exception exception) at RedGate.SQLPrompt.VsPackage.SQLPromptPackage.<InitializeAsync>d__2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.VisualStudio.Shell.AsyncPackage.<>c__DisplayClass16_0.<<Microsoft-VisualStudio-Shell-Interop-IAsyncLoadablePackageInitialize-Initialize>b__1>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.VisualStudio.Threading.JoinableTask.<JoinAsync>d__78.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.VisualStudio.Services.VsTask.RethrowException(AggregateException e) at Microsoft.VisualStudio.Services.VsTask.InternalGetResult(Boolean ignoreUIThreadCheck) at Microsoft.VisualStudio.Services.VsTask.GetResult()System.TypeLoadException: Could not load type 'System.Diagnostics.Activity' from assembly 'System.Diagnostics.DiagnosticSource, Version=4.0.1.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51'. at Microsoft.ApplicationInsights.Extensibility.TelemetryConfiguration.<>c.<.cctor>b__13_0() at Microsoft.ApplicationInsights.ActivityExtensions.TryRun(Action action) at Microsoft.ApplicationInsights.Extensibility.TelemetryConfiguration..cctor() End package load [SQLPromptPackage] I have "Application Insights Tools for Visual Studio Package - 8.14.20131.1" extension installed - part of the "Developer Analytics Tools" extension from Microsoft. I tested both disabling and uninstalling the "Developer Analytics Tools" (and restarting), but neither of these changed the outcome.   / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 10.5.x not loading in Visual Studio 2017/2019
Thanks for the update. I tried this, but no change. Not noted before, the SQL Prompt main menu item fails to show when opening any SQL file.  I tested on Visual Studio 2017 Enterprise 15.9.30.The f...
0 votes
I can confirm that if I revert to version 10.4.7, the problem goes away. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 10.5.x not loading in Visual Studio 2017/2019
I can confirm that if I revert to version 10.4.7, the problem goes away.
0 votes
SQL Prompt 10.5.x not loading in Visual Studio 2017/2019
  1. Community
  2. SQL Prompt
I mostly use SQL Prompt in SSMS 18.x - and it's working fine there.However, when trying to use in Visual Studio 2017 (or 2019) to format SQL code, the moment I enter the "Format SQL", I get an erro...
5 followers 17 comments 0 votes
Thanks for the work-around.   In my case, data sets are small, and therefore removing and attaching the FK is of little consequence. And I guess this would would generally be true for any data that has been included as Data Tables in SCA I do see it as a work-around - since the automatically generated script generated  by SCA did not work, and failed it's own verification. I consider this a fairly trivial case. Data2 depends on Data1. (Directly in this case with a FK relationship). Data1 has no dependencies on Data2. => Generate new Data1 records before applying updates to Data2 I was not expecting this to be beyond the compare engine used by SCA. / comments
  1. Community
  2. SQL Change Automation
  3. Updating multiple Data tables - generate script incorrect
Thanks for the work-around.   In my case, data sets are small, and therefore removing and attaching the FK is of little consequence. And I guess this would would generally be true for any data that...
0 votes
Updating multiple Data tables - generate script incorrect
  1. Community
  2. SQL Change Automation
I have added a number of tables as Data Tables to my SCA project in Visual Studio 2017.  I and using release 4.2.20176.I added data to two tables, one of them a FK reference to the other.The proble...
2 followers 2 comments 0 votes
Since there have been no other comments, I guess it's fairly safe to assume that I'm the only one experiencing this. I try again, assuming it's something on my side .... / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt 10.2.x release causing random code substitutions when code suggestions are enabled
Since there have been no other comments, I guess it's fairly safe to assume that I'm the only one experiencing this. I try again, assuming it's something on my side ....
0 votes
SQL Prompt 10.2.x release causing random code substitutions when code suggestions are enabled
  1. Community
  2. SQL Prompt
Since upgrading to SQL Prompt 10.2.0 (and subsequently 10.2.1), I have started having problems in SSMS version 17.9.1.After a random amount of time (~1 - 30 minutes) I am finding that suddenly star...
4 followers 7 comments 0 votes
Total activity
24
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
7