Maximize the power of SQL Prompt with SQL Toolbelt Essentials. Watch now.

Active Formatting Style reverts to default after SSMS restart

fscottffscottf Posts: 4 Bronze 1
edited February 7, 2022 5:11PM in SQL Prompt
After upgrading SQL Prompt, the active Formatting Style reverts to the 'Default' setting each time I restart SSMS.   The behavior occurs whether I select a 'Custom style' or a non-Default 'Redgate Style.'

No other intervening actions are needed to duplicate the issue.  If I open  SSMS, then immediately go to SQL Prompt > Options > Format/Styles > Edit formatting styles ... > Select 'Collapsed Style' (for example) > Set As Active > Close (button) > Ok (button) > Close SSMS > Open SSMS => style is set back to 'Default'

I've been using Redgate for about 3 years, and have kept current on all updates.  And have used custom styles throughout that time without issue until this upgrade. 

Thanks for any help!

Redgate SQL Prompt Version:
SQL Server Management Studio 15.0.18390.0
SQL Server Management Objects (SMO) 16.100.46521.71
Microsoft Analysis Services Client Tools 15.0.19714.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.19043


Sign In or Register to comment.