QUERY_CAPTURE_MODE = CUSTOM
torsten.strauss
Posts: 271 Silver 3
in SQL Prompt
Hi Redagte Team,
SQL Prompt will raise on error formatting the following code:
SQL Prompt will raise on error formatting the following code:
ALTER DATABASE Current
SET QUERY_STORE (OPERATION_MODE = READ_WRITE, QUERY_CAPTURE_MODE = CUSTOM)
GO
Thanks for fixing!
Thanks for fixing!
Tagged:
Answers
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
Thanks!
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
The syntax is valid in SQL Server 2019.
Thanks for your patience with this.
I was able to hear back from the developers and can confirm that this should work better now.
Can you try upgrading to the below version and see if that helps?
https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.1.7.15015.exe
Thanks!
Sean Quigley | Product Support Engineer | Redgate Software
Have you visited our Help Center?
Unfortunately, SQL Prompt will still fail to format the code
Unfortunately, this issue is caused by a parsing error in the Microsoft T-SQL parser that we use for formatting, so there's not a huge amount we can do except report the issue to Microsoft.
Thanks,
Tom
Redgate Software