SSMS Hanging

SQL_Prompt_Fan

Hi,

I am experiencing issues where SSMS is hanging which forces me to shut it down via Task Manager -> End Task.

Always hangs when writing a SQL Query and SQL Prompt is providing suggestions.

The following is the about information of SSMS:

SQL Server Management Studio 15.0.18330.0

SQL Server Management Objects (SMO) 16.100.37971.0

Microsoft Analysis Services Client Tools 15.0.19040.0

Microsoft Data Access Components (MDAC) 10.0.18362.1

Microsoft MSXML 3.0 6.0 

Microsoft .NET Framework 4.0.30319.42000

Operating System 10.0.18363

The version of SQL Prompt I have is 10.6.19.22.

Any suggestions on how to get around this problem

Victoria W

Hi @SQL_Prompt_Fan

Please can you enable verbose logging, reproduce the error and attach the log files? If you're not happy to attach them in the forum you can send them to support@red-gate.com and we'll raise a support ticket for you.

https://documentation.red-gate.com/sp/troubleshooting/finding-the-sql-prompt-log-files