Options
ALTER DATABASE SET QUERY_STORE CLEAR ALL
torsten.strauss
Friend of Redgate › Posts: 266 Silver 3
in SQL Prompt
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
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
Tagged:
Comments
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
Redgate Software
We fixed it and it will come out in new release 8.0.5.
Best Regards,
Krzysztof