How can we help you today? How can we help you today?

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

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.
RobinT
0

Comments

8 comments

Sort by
  • RobinT
    @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
    RobinT
    0
  • Alex B
    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
    Alex B
    0
  • Alex B
    Hi all,

    We believe version 9.2.8 will correct this issue.  Please download it from the ftp here.  I had disabled my suggestions and had to re-enable them after updating, then restart SSMS once for it to all work properly.

    Kind regards,
    Alex
    Alex B
    0
  • bhmsch
    I was another experiencing this issue since last week and confirmed 9.2.8 fixed this.  Thanks!
    bhmsch
    0
  • Bert De Haes
    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)




    Bert De Haes
    0
  • jcarey
    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
    jcarey
    0
  • RobinT
    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).
    RobinT
    0
  • jcarey
    The new version 9.4.5.7296 fixed me.
    jcarey
    0

Add comment

Please sign in to leave a comment.