What are the challenges you face when working across database platforms? Take the survey
Options

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.

Best Answer

Answers

  • Options
    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
  • Options
    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?
  • Options
    bhmschbhmsch Posts: 2 New member
    I was another experiencing this issue since last week and confirmed 9.2.8 fixed this.  Thanks!
  • Options
    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)




  • Options
    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
  • Options
    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).
  • Options
    jcareyjcarey Posts: 5 New member
    edited December 3, 2018 5:17PM
    The new version 9.4.5.7296 fixed me.
Sign In or Register to comment.