Activity overview
Latest activity by SCrouchman
So it sounds like you're seeing the same as me, its just that my example is a bit contrived. Under normal usage I wouldn't want to disconnect the instance, its in my example because its the only way to get it to start working normally. If you actually try to use the object explorer for anything it pauses every time, which is what you're describing. That to me is unusable, regardless of whether it never comes back or not. There is clearly something SQL prompt is doing every time I interact with object explorer which is causing it to try and communicate with the sql instance it can no longer reach and it has a very long timeout. / comments
So it sounds like you're seeing the same as me, its just that my example is a bit contrived. Under normal usage I wouldn't want to disconnect the instance, its in my example because its the only wa...
It doesn't crash for me either it just hangs. However it is bad enough with SQLPrompt installed that I have to force kill SSMS to be able to use it again. I've been running without that extension for a few days now, I get the occasional slow response when switching networks but it is a lot more usable than it was before. / comments
It doesn't crash for me either it just hangs. However it is bad enough with SQLPrompt installed that I have to force kill SSMS to be able to use it again.I've been running without that extension fo...
So, its definitely SQLPrompt & SQLSourceControl thats causing the issue, with SQLPrompt being the biggest offender. Steps followed for each test
Make sure SSMS is closed
Move an extension back into the correct folder
Open SSMS
Connect to VPN
Connect to Server in SSMS
Disconnect from VPN
Connect to local Server in SSMS (via object explorer)
Disconnect from Server from step 5
With SQLSourceControl I can connect and interact with my local Server fine, but loading the context menu to disconnect from the other server locks up SSMS. However it does eventually load and I can keep opening the context menu with no issues. Trying to right click on any of the databases on that server does the same thing With SQLPrompt I can't even connect to my local server, it locks up immediately when I try to click anywhere in Object explorer. It does eventually respond and I can connect to my local server, but if I disconnect and try to reconnect same issue again. Also whenever I try to interact with the original server in anyway it locks up, this means if I right click to disconnect it will hang before showing the context menu, and often the menu will disappear when it becomes responsive again and I have to force quit ssms. Hope this helps, happy to try anything here. I could probably live without SQLSourceControl as only one of our systems uses that, but SQLPrompt is the main reason for having the toolbelt installed / comments
So, its definitely SQLPrompt & SQLSourceControl thats causing the issue, with SQLPrompt being the biggest offender.Steps followed for each test
Make sure SSMS is closed
Move an extension back into ...
Sorry for the confusion, this is currently a constant issue. What I've done is disabled the option to reconnect tabs, this is so that I can force quit ssms and safely reopen it again. If I dont do this when I reopen ssms it just locks up again. To get around it originally I had to connect back to the vpn again so everything started responding and close all tabs and open servers. Confirmed this is definitely a redgate issue. If I follow those steps and remove all the extensions, I can safely disconnect from the VPN and keep using SSMS with the non available server still open in object explorer. If I put the extensions back and repeat the test, the moment I start interacting with SSMS after I disconnect it locks up, the only resolution is to force quit or reconnect to the vpn again, wait for it to start responding and then disconnect the server in object explorer. I'll try removing those extensions 1 by 1 to see if I can narrow it down / comments
Sorry for the confusion, this is currently a constant issue.What I've done is disabled the option to reconnect tabs, this is so that I can force quit ssms and safely reopen it again. If I dont do t...
So just tried it, it happens even with no tabs open. All I have to do is click in the object explorer pane and it locks up if the server isn't accessible anymore. Is there a way to disable ALL redgate sql products without uninstalling? I don't remember having this issue before but should probably check and confirm that / comments
So just tried it, it happens even with no tabs open. All I have to do is click in the object explorer pane and it locks up if the server isn't accessible anymore.Is there a way to disable ALL redga...