SQL Prompt makes SSMS crash when "Enable Suggestions" is enabled

RobinTRobinT Posts: 3 New member
edited September 4, 2018 10:57AM in SQL Prompt
I am running SSMS 2017 (17.8.1)  on Windows 10 with the following component versions:

Microsoft SQL Server Management Studio 14.0.17277.0
Microsoft Analysis Services Client Tools 14.0.1016.262
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 Prompt is in version 9.2.7.6282.

SSMS works perfectly fine when the SQL Prompt setting "Enable Suggestions" is disabled, but as soon as I enable it and try to type any query SSMS freezes and generates an error saying "Is Busy. SQL Server Management is waiting for an internal operation to complete. If you encounter this problem... report it to Microsoft.".

I have reinstalled both SQL Prompt and SSMS without success.
Tagged:
· Share on Twitter

Best Answer

Answers

  • RobinTRobinT Posts: 3 New member
    @TheoL
    Thank you for the answer!

    Did you find the installation file for 9.1 on red-gates website? It is not on https://www.red-gate.com/products/old-versions
    · Share on Twitter
  • Alex BAlex B Posts: 1,157 Diamond 4
    Hi @RobinT and @TheoL,

    I think the developers are near a fix for this issue.  I personally saw it start in 9.2.7.

    You can download 9.2.6 here.

    Also, here is a link to 9.1.16  from our ftp.

    Keep an eye out for 9.2.8 which I believe will help with this issue!

    Kind regards,
    Alex
    Product Support Engineer | Redgate Software

    Have you visited our Help Center?
    · Share on Twitter
  • bhmschbhmsch Posts: 2 New member
    I was another experiencing this issue since last week and confirmed 9.2.8 fixed this.  Thanks!
    · Share on Twitter
  • Bert De HaesBert De Haes Posts: 3 Bronze 1
    I have now the same problem : SSMS completely freezes after a while when "Enable Suggestions" is enabled.

    Used versions:

    Microsoft SQL Server Management Studio 14.0.17285.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

    and connected to

    Microsoft SQL Server 2016 (SP1-CU5) (KB4040714) - 13.0.4451.0 (X64) 
    Sep  5 2017 16:12:34 
    Copyright (c) Microsoft Corporation
    Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2012 Standard 6.2 <X64> (Build 9200: ) (Hypervisor)




    · Share on Twitter
  • jcareyjcarey Posts: 5 New member
    edited November 28, 2018 7:38PM
    I am also seeing the same with "Enable Suggestions" and/or "Enable Code Analysis" are enabled when ever I place my cursor on any of the underlined text from the suggestions or analysis.  

    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
    · Share on Twitter
  • RobinTRobinT Posts: 3 New member
    I have not had any problems since installing SQL Prompt 9.2.8. However, I see that I am running SSMS 14.0.17285 while both of you are running 14.0.17289 (I have the same SQL Prompt version as you).
    · Share on Twitter
  • jcareyjcarey Posts: 5 New member
    edited December 3, 2018 5:17PM
    The new version 9.4.5.7296 fixed me.
    · Share on Twitter
Sign In or Register to comment.