ALTER DATABASE CURRENT SET QUERY_STORE(INTERVAL_LENGTH_MINUTES=1)

torsten.strauss

Hi redgate team,

the following statement will cause a formatting error:

ALTER DATABASE CURRENT SET QUERY_STORE(INTERVAL_LENGTH_MINUTES=1);
GO

Thanks for looking into this!

Torsten
Friend of Redgate

FredericoJ

Hi Torsten,

Thanks for letting us know.

We've managed to replicate the issue here and I've created an internal bug (reference: SP-6447) to track it.

Best regards,

Frederico

FredericoJ

Hi @torsten.strauss,

We've fixed this issue in our latest version of SQL Prompt 8.0.6.1890 (installer here).

You can find more information about this release in this forum post.

Kind regards,

Frederico

torsten.strauss

Hi Frederico!

I can confirm that the issue is solved with the update.

Thanks!

Torsten