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

• 
  Currently no unfortunately - disable code analysis for now whilst we investigate.

  Russell D November 26, 2018 08:45

  - 0 +
• 
  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).
  

  csand November 26, 2018 09:16

  - 0 +
• 
  And if you disable CA?

  Russell D November 26, 2018 09:32

  - 0 +
• 
  Then the problem does not occur. But that con only be a temporarily solution
  

  csand November 26, 2018 09:35

  - 0 +
• 
  I appreciate that - but it helps us narrow down where the problem is.

  Russell D November 26, 2018 09:53

  - 0 +
• 
  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

  
  

  jcarey November 28, 2018 19:59

  - 0 +
• 
  I am having exactly the same issues since the automatic fix suggestions release.

  achamp29 November 29, 2018 09:21

  - 0 +
• 
  We tested a private build successfully for this and will push it out later today.

  Russell D November 30, 2018 13:04

  - 0 +
• 
  Same problem. Looking forward to the fix.

  jgraves November 30, 2018 20:31

  - 0 +
• 

  Russell D said:

  We tested a private build successfully for this and will push it out later today.

  Did the hot fix push out?

  jgraves December 01, 2018 16:18

  - 0 +
• 
  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.

  Russell D December 03, 2018 08:13

  - 0 +
• 
  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.

  Russell D December 03, 2018 15:15

  - 0 +
• 
  Thanks. The new version fixes the Problem for me.
  

  csand December 03, 2018 15:18

  - 0 +
• 
  I installed the update but unfortunately am still having the same issue... disabling Enable Code Analysis solves the issue.

  eforden December 03, 2018 17:04

  - 0 +
• 
  Thanks, the new version 9.4.5.7296 fixed me.

  jcarey December 03, 2018 17:13

  - 0 +
• 
  It seems like 9.4.5.7296 fixed it for me as well.
  Thanks.

  Mogens_Olesen December 03, 2018 17:44

  - 0 +
• 
  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

  eforden December 04, 2018 17:40

  - 0 +
• 
  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.

  jcarey December 04, 2018 17:45

  - 0 +
• 
  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. 
  

  ScottA December 30, 2018 04:01

  - 0 +
• 

  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
  

  kstephens January 09, 2019 17:15

  - 0 +
• 
  This problem went away on my previous version and now it's back.
  
  9.4.7.7595 appears to suffer from the same issue

  RichT January 09, 2019 21:47

  - 0 +

Add comment

Please sign in to leave a comment.