ALTER DATABASE SET QUERY_STORE CLEAR ALL

torsten.strauss

Hi Redgate Team!

The following statement will cause an issue

ALTER DATABASE AdventureWorks2016 SET QUERY_STORE CLEAR ALL
GO

Formatting will add a semicolon after CLEAR which invalids the statement!

ALTER DATABASE AdventureWorks2016 SET QUERY_STORE CLEAR; ALL
GO

Thanks for looking into this!

Regards
Torsten
Friend of Redgate

FredericoJ

Hi Torsten,

Thank you for reporting this.

I've managed to reproduce the problem locally and I've created a bug (reference: SP-6432) to track it.

Best regards,

Frederico

krzysztofkroczak

Hi Torsten,

We fixed it and it will come out in new release 8.0.5.

Best Regards,
Krzysztof