What are the challenges you face when working across database platforms? Take the survey
Options

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
Tagged:

Comments

Sign In or Register to comment.