How can we help you today? How can we help you today?

ALTER DATABASE SET QUERY_STORE CLEAR ALL

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
torsten.strauss
0

Comments

2 comments

Sort by
  • 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
    FredericoJ
    0
  • krzysztofkroczak
    Hi Torsten,

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

    Best Regards,
    Krzysztof
    krzysztofkroczak
    0

Add comment

Please sign in to leave a comment.