Randomly start getting errors while formatting any kind of SQL code - SSMS restart required
EmilV
Posts: 6 Bronze 1
in SQL Prompt
Hello
Every couple of hours (depending on how active I am in SSMS), my SQL Prompt will start erroring out on every single Format SQL (Ctrl+K, Ctrl+Y) command, regardless of what T-SQL code I'm currently trying to format.
It's always the "Apply layout (format SQL) (Exception)" that pops up. I have to restart SSMS completely before I can format SQL again.
Has anyone experienced this before? It started a couple of updates ago..
See screenshot of the GUI error and associated extract of the log file.
SQL Prompt version: 10.6.2.18034
SSMS version/info
Every couple of hours (depending on how active I am in SSMS), my SQL Prompt will start erroring out on every single Format SQL (Ctrl+K, Ctrl+Y) command, regardless of what T-SQL code I'm currently trying to format.
It's always the "Apply layout (format SQL) (Exception)" that pops up. I have to restart SSMS completely before I can format SQL again.
Has anyone experienced this before? It started a couple of updates ago..
See screenshot of the GUI error and associated extract of the log file.
SQL Prompt version: 10.6.2.18034
SSMS version/info
- SQL Server Management Studio 15.0.18369.0
- SQL Server Management Objects (SMO) 16.100.46041.41
- Microsoft Analysis Services Client Tools 15.0.19342.0
- Microsoft Data Access Components (MDAC) 10.0.19041.1
- Microsoft MSXML 3.0 6.0
- Microsoft .NET Framework 4.0.30319.42000
- Operating SYSTEM 10.0.19042
Tagged:
Answers
Thank you. I'm having issues seeing any support tickets when I try login via the "Support log in" link on Support (red-gate.com). I get redirected back to the support page