SQL Prompt causes SSMS to hang when 'Enable Code Analysis' is enabled

Hi
I just updated to the latest 9.4.4.7199 because the previous version (i think it was 9.4.3) had the this problem.
It appears still to be the case.

Any solutions?

Answers

  • Currently no unfortunately - disable code analysis for now whilst we investigate.
    Have you visited our Help Centre?
  • csandcsand Posts: 6 Bronze 1
    edited November 26, 2018 9:19AM
    Same Problem here. I just too updated to the newest version and also had the Problem in the previous version.
    It only happens when I click with the mouse on the underlined word.
    When navigating with the keyboard there is no problem at all

    Minimizing the window (by clicking the SSMS icon the Windows taskbar) and then maximizing the window again, temporarily solves the problem (until I accidentily click an underlined word).
  • And if you disable CA?
    Have you visited our Help Centre?
  • csandcsand Posts: 6 Bronze 1
    Then the problem does not occur. But that con only be a temporarily solution
  • I appreciate that - but it helps us narrow down where the problem is.
    Have you visited our Help Centre?
  • jcareyjcarey Posts: 5 New member
    I am seeing the same thing with both "Enable Suggestions" and/or "Enable Code Analysis" enabled when ever I place my cursor on any of the underlined text from both. 

    I can recover with pressing the esc key and then clicking away from SSMS and then back in and quickly clicking away from the underlined text.  If I don't do this it will end up hanging to the point of crashing my SSMS.  

    System information:
    Microsoft SQL Server Management Studio 14.0.17289.0
    Microsoft Analysis Services Client Tools 14.0.1016.283
    Microsoft Data Access Components (MDAC) 10.0.17134.1
    Microsoft MSXML 3.0 6.0 
    Microsoft Internet Explorer 9.11.17134.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 6.3.17134
    SQL Promt version : 9.4.4.7199

  • achamp29achamp29 Posts: 1 New member
    I am having exactly the same issues since the automatic fix suggestions release.
  • We tested a private build successfully for this and will push it out later today.
    Have you visited our Help Centre?
  • jgravesjgraves Posts: 12 New member
    Same problem. Looking forward to the fix.
  • jgravesjgraves Posts: 12 New member
    Russell D said:
    We tested a private build successfully for this and will push it out later today.
    Did the hot fix push out?
  • I'm afraid not. I checked up with the release and it looks like we had a problem with the build servers. The plan is to release today. I'll keep you posted.
    Have you visited our Help Centre?
  • This has now been released, you can get it through CfU or directly here http://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_9.4.5.7296.exe.
    Have you visited our Help Centre?
  • csandcsand Posts: 6 Bronze 1
    Thanks. The new version fixes the Problem for me.
  • efordeneforden Posts: 2 New member
    I installed the update but unfortunately am still having the same issue... disabling Enable Code Analysis solves the issue.
  • jcareyjcarey Posts: 5 New member
    edited December 3, 2018 5:14PM
    Thanks, the new version 9.4.5.7296 fixed me.
  • It seems like 9.4.5.7296 fixed it for me as well.
    Thanks.
  • efordeneforden Posts: 2 New member
    I did some further testing on my SSMS locking up and believe I've isolated it to a specific situation.

    When code analysis highlights an issue with the green squiggly underline, if I just right-click on that issue that issue, SSMS will lock up.  If I first double left-click on that issue, and then right-click SSMS does not lock up.

    When SSMS does lock up I can recover at any time by clicking Ctrl-Esc
  • jcareyjcarey Posts: 5 New member
    I tested that same thing and in fact get the same response.  It will lock up as before if I just right click on the green underlined text without double clicking to place the cursor there first as well.  
  • ScottAScottA Posts: 9 Bronze 1
    I'm having the same problem and have had to turn off code analysis. 

    repro steps:

    type "exec spMyStoredProcedure" (leaving out the dbo.)

    This will trigger an issue "Schema name for procedure is not specified" as i didn't put in dbo.

    Right click the spMyProcedure (to say do script as alter), Will hang and the issue icon will flicker. 
  • kstephenskstephens Posts: 1 New member
    edited January 9, 2019 5:21PM
    ScottA said:
    I'm having the same problem and have had to turn off code analysis. 

    repro steps:

    type "exec spMyStoredProcedure" (leaving out the dbo.)

    This will trigger an issue "Schema name for procedure is not specified" as i didn't put in dbo.

    Right click the spMyProcedure (to say do script as alter), Will hang and the issue icon will flicker. 
    We have the same issue on 2 machines.
    If I add dbo. in I still get the same problem though.

    Works normally with code analysis off.


    jcarey said:
    I tested that same thing and in fact get the same response.  It will lock up as before if I just right click on the green underlined text without double clicking to place the cursor there first as well.  

    +1

    eforden said:
    I did some further testing on my SSMS locking up and believe I've isolated it to a specific situation.

    When code analysis highlights an issue with the green squiggly underline, if I just right-click on that issue that issue, SSMS will lock up.  If I first double left-click on that issue, and then right-click SSMS does not lock up.

    When SSMS does lock up I can recover at any time by clicking Ctrl-Esc
    +1
  • RichTRichT Posts: 2 New member
    This problem went away on my previous version and now it's back.

    9.4.7.7595 appears to suffer from the same issue :cry:
Sign In or Register to comment.