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

Comments

Sort by recent activity
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
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
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
MayaMalakova said: TheoL said: Does this mean those on Toolbelt Essentials essentially lose this functionality completely (for new projects)?   We left a backdoor for those that really want to continue using it - you can set AlwaysEnableMigrationsPage to True in the UI options in %LOCALAPPDATA%\Red Gate\SQL Source Control 7\RedGate_SQLSourceControl_CommonUI_UIOptions.xml Unless the feature actively maintains inter-operability with future versions of SQL Compare  and SQL Change Automation, then this is only a temporary solution. / comments
  1. Community
  2. SQL Source Control
  3. Built-in migrations feature deprecated in SQL Source Control 7.1.9
MayaMalakova said: TheoL said: Does this mean those on Toolbelt Essentials essentially lose this functionality completely (for new projects)?   We left a backdoor for those that reall...
0 votes
Does this mean those on Toolbelt Essentials essentially lose this functionality completely (for new projects)? / comments
  1. Community
  2. SQL Source Control
  3. Built-in migrations feature deprecated in SQL Source Control 7.1.9
Does this mean those on Toolbelt Essentials essentially lose this functionality completely (for new projects)?
0 votes
@DanC I have found the cause: For performance, I use "Only load suggestions for certain databases/schemas" option.  My freshly installed SQL Express 2017 was not in the list.  The fact it was SQL Express 2017 was not related to the cause. It turns out the if the database is not included in the server/database list for connections, then the Find Invalid Objects does not work. It would be a sensible UI enhancement to notify the user that this is the case instead of allowing the attempt, then just showing a progress bar that appears to get stuck at about 10%. / comments
  1. Community
  2. SQL Prompt
  3. Find Invalid Object not working on SQL Express 2017
@DanC I have found the cause:For performance, I use "Only load suggestions for certain databases/schemas" option.  My freshly installed SQL Express 2017 was not in the list.  The fact it was SQL Ex...
0 votes
Hi, @DanC I was attempting to use the "Find Invalid Objects" feature of SQL Prompt, by right clicking on a database in the SSMS object explorer, then selecting the "Find invalid objects" menu item. It is the resulting "SQL Prompt - Invalid Objects" window that hangs - there is no script involved. / comments
  1. Community
  2. SQL Prompt
  3. Find Invalid Object not working on SQL Express 2017
Hi, @DanCI was attempting to use the "Find Invalid Objects" feature of SQL Prompt, by right clicking on a database in the SSMS object explorer, then selecting the "Find invalid objects" menu item.I...
0 votes
Same issue here. SQL Search effectively useless while this problem exists. / comments
  1. Community
  2. SQL Search
  3. SQL Search not returning any results
Same issue here. SQL Search effectively useless while this problem exists.
0 votes
I am now having the same symptom with update 9.4.7.7595.  "The bug is back!" Win 10 x64 - latest updates. / comments
  1. Community
  2. SQL Prompt
  3. SQL Prompt Installed issues
I am now having the same symptom with update 9.4.7.7595.  "The bug is back!"Win 10 x64 - latest updates.
0 votes
Total activity
24
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
7