Best Of
Source Control causing SSMS to crash frequently
This seems to happen when I introduce a new server and try and act with it in the object browser. Happening frequently since yesterday morning.
Once it started happening I updated my source-control to the latest version but it is still happening.
Error log below.
FYI: this is also coinciding with an issue where SSMS closing it is prompting it to restart.
2024-03-21 17:12:06.553 +00:00|Warning|RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.AppDomainWideSetup|112| Unhandled Exception: Exception has been thrown by the target of an invocation.. IsTerminating : true
Once it started happening I updated my source-control to the latest version but it is still happening.
Error log below.
FYI: this is also coinciding with an issue where SSMS closing it is prompting it to restart.
2024-03-21 17:12:06.553 +00:00|Warning|RedGate.SQLSourceControl.Engine.Utils.DependencyResolution.AppDomainWideSetup|112| Unhandled Exception: Exception has been thrown by the target of an invocation.. IsTerminating : true
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.MissingMethodException: Method not found: 'Void RedGate.SIPFrameworkShared.DatabaseConnectionDescriptor.set_AccessToken(System.String)'.
at RedGate.SIPFramework.Services.Wrappers.DatabaseConnectionInfo..ctor(IConnectionProperties connectionProperties)
at RedGate.SIPFramework.Services.ServicesToPlugins.ObjectExplorerWatcher.<>c.<OnConnectionsChanged>b__14_0(IConnectionProperties conn)
at System.Linq.Enumerable.WhereSelectListIterator`2.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at RedGate.SIPFramework.Services.ServicesToPlugins.ObjectExplorerWatcher.OnConnectionsChanged(Object sender, ObjectExplorerConnectionsChangedEvent e)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorerShared.InvokeOnConnectionsChanged(ObjectExplorerConnectionsChangedEvent e)
at RedGate.SharedSSMS.VersionSpecific.ObjectExplorer2012Plus.OnObjectExplorerContextChanged(Object sender, NodesChangedEventArgs args)
--- End of inner exception stack trace ---
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.Delegate.DynamicInvokeImpl(Object[] args)
at Microsoft.SqlServer.Management.SqlStudio.Explorer.BufferedNotification.Fire()
at Microsoft.SqlServer.Management.SqlStudio.Explorer.BufferedNotification.<StartTimer>b__2(Object state)
at System.Threading.TimerQueueTimer.CallCallbackInContext(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.TimerQueueTimer.CallCallback()
at System.Threading.TimerQueueTimer.Fire()
at System.Threading.TimerQueue.FireNextTimers()
at System.Threading.TimerQueue.AppDomainTimerCallback(Int32 id)
kalo
1 ·
Re: Tab History Removal - Why??????
ATurner - Did you not run this by anyone in legal or public relations first? Your very first sentence has an undertone of sarcasm and frustration. Yes you follow it up with your reading feedback and working on the thing but when you are engaging with your customers about a mess you caused I wouldn't tell them "X has replaced Y and X isn't coming back". You instead could have written something like this:ATurner said:Hi all,
SQL History has replaced tab history, thus it will not be coming back. However, the team is actively reading your feedback on what can be done to improve SQL History. In order to help us prioritize our development efforts, we would like to ask you to provide us with some concrete examples on how SQL history is not meeting your needs. This will help us understand your pain points better and address them more effectively.
"SQL History has replaced Tab History in such a way that we can't bring Tab History back. Hindsight is always 20/20 and if we could have done it differently we would have but we can't. What we are doing is working on trying to fix SQL history and with your feedback we hope that it will one day be to you what Tab History was if not more."
Do you see the difference? Your message comes across like a frustrated parent disciplining their child; not a very good way to engage with your customers. Were you the one that made the call to replace Tab History with SQL History and so now you're frustrated that so many aren't happy with that decision? Or were you the one who created SQL History and so now your angry that so many are calling it garbage? I've enaged with RG employe Steve Jones many times and some where more complaints than compliments yet Steve was always professional.
EdCarden
2 ·
Re: Tab History Removal - Why??????
Well said EdCarden.
Alas I fear 'the team' will ignore you comments like they have all the others :-(
The next bet should be what other much loved feature will silently disappear in the night....
Alas I fear 'the team' will ignore you comments like they have all the others :-(
The next bet should be what other much loved feature will silently disappear in the night....
jimVisage1980
1 ·
Re: Tab History Removal - Why??????
Here are a few pain points.
1. Ouch. That melon-sized Search throbber. Why flash half the screen while the app does its work? We all know that a throbber is just an animated gif that doesn't really show any work is being done. This one is a real eye-stabber. Just drop it.
2. Do some QA on using keyboard-only to navigate. Behavior is really inconsistent. Sometimes focus will completely disappear, forcing me to use the mouse to get on a focused item. This happens if you up-arrow beyond the top item, but also for what seems like no reason at all. When you first open SQL History, nothing is focused, and you can't use the keyboard to gain focus. It should initially set focus on the Recent Queries list. Search result should do the same after results are returned.
3. Don't steal the ctrl-tab key! Stepping through tabs gets stuck on SQL History and I can't ctrl-tab out of it, having to remember that, oh yeah, use Esc to get out. Once in SQL History, ctrl-tab does the same thing as tab, so I think this is probably a bug.
4 Still wish it was as snappy as Tab History. That thing was FAST.
Thanks, and I hope someone reads this!
GaryH
1 ·
all activity at point in time
Hi- Is it possible to view all SQL activity at a specific point in time? The current activity results are, well current. Is there a way to go back to a specific minute to see what was occurring? The top queries in the overview shows some but not all of what I am looking for. Also, top queries does not show all spids at a specific minute. Please let me know if that functionality is available or not. I read forum thread https://forum.red-gate.com/discussion/89527/sql-monitor-show-all-activity and it seems close to what I am asking about but not sure.
Thanks,
Mark Maddox
Thanks,
Mark Maddox
MarkMaddox
1 ·
Suggestions Stopped Working After Upgrade to Version 10.14.12.7945
I upgraded SQL Prompt to Version 10.14.12.7945 yesterday and no longer get suggestions or some auto-formatting features in SSMS v18.12.1. I do not use SQL Prompt anywhere else, so I cannot confirm if this is limited to SSMS.
Features NOT Working:
Features Still Working:
Tried disabling and reenabling SQL Prompt > Enable Suggestions. Also tried Refresh Suggestions, no change. Also tried rebooting my machine but that hasn't made a difference.
UPDATE: Noted the error below in the logs following the update. The log file includes the actual correct server name. Replacing the server name with placeholder <servername> in this post.
Is there a way to manually correct the ServerCandidate connection settings? I'm not seeing any obviously related settings in the SQL Prompt menu or options.
Features NOT Working:
- No suggestions displayed when typing an object name.
- Schema name is not automatically inserted when typing an object name.
- Schema name is not inserted when running Format SQL or Qualify Object Names.
- Pressing tab after * no longer expands the wildcard to display field names.
- Running Expand Wildcards does not work either.
Features Still Working:
- Built-in shortcuts appear to be working. For example, typing 'ssf' does expand to 'SELECT * FROM'.
- Apply Casing Options is working as expected.
- Insert Semicolons is working as expected.
- Remove Square Brackets is working as expected.
Tried disabling and reenabling SQL Prompt > Enable Suggestions. Also tried Refresh Suggestions, no change. Also tried rebooting my machine but that hasn't made a difference.
UPDATE: Noted the error below in the logs following the update. The log file includes the actual correct server name. Replacing the server name with placeholder <servername> in this post.
2024-04-03 08:46:23.782 -05:00 [Information] Created new ServerCandidate for server: <servername>
2024-04-03 08:46:53.519 -05:00 [Warning] Failed to load server <servername>
Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: HTTP Provider, error: 0 - )
No other logs mention "Created new ServerCandidate" but they do include a similar error, indicating a connection problem.
No other logs mention "Created new ServerCandidate" but they do include a similar error, indicating a connection problem.
2024-04-02 15:26:12.397 -05:00 [Error] Error checking for platform availability
System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
Is there a way to manually correct the ServerCandidate connection settings? I'm not seeing any obviously related settings in the SQL Prompt menu or options.
Ashlee
1 ·
prompt AI+ makes ssms close down (not answered)
Hello there,
I've just upgrade my SQL Prompt to version 10.14.11.7894, now when i highlight some code a small ai+ icon appear, if i click it the prompt opens but if i click out of it, my whole SSMS closes down. Is there anything i can do to disable this "feature" of the ai+ icon appearing? i do not like it, and i do not like that it closes down my ssms
SQL Server Management Studio 19.2.56.2
I've just upgrade my SQL Prompt to version 10.14.11.7894, now when i highlight some code a small ai+ icon appear, if i click it the prompt opens but if i click out of it, my whole SSMS closes down. Is there anything i can do to disable this "feature" of the ai+ icon appearing? i do not like it, and i do not like that it closes down my ssms
SQL Server Management Studio 19.2.56.2
SQL Server Management Objects (SMO) 16.200.48050.0+9bd30730a8cbcdac9d9788ba6605f3dda96e6b89
Microsoft T-SQL Parser 17.0.23.0+0d40faadb307b5d5fe930d64f47d2285ed3d0831
Microsoft Analysis Services Client Tools 16.0.20054.0
Microsoft Data Access Components (MDAC) 10.0.22621.3296
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.22631
LarsSandahl
1 ·
Re: How do I turn off SQL Prompt+ AI?
That's a really poor design forcing something so intrusive on users. The constant popup of that icon is particularly annoying.
BobbyOwens
1 ·
How do I turn off SQL Prompt+ AI?
How do I turn off SQL Prompt+ AI? I tried it and disliked it as it was totally pointless and unusable
Twice I have now accidentally opened it and it has locked up SSMS and made it end up crashing and restarting.
Twice I have now accidentally opened it and it has locked up SSMS and made it end up crashing and restarting.
BobbyOwens
1 ·
Re: SQL Prompt and Azure Data studio
Bump. I think a lot of people are still hoping to SQL prompt for VS code or Azure Data Studio
ejbiker93ss
1 ·