Using SSMS 2016 Query Store I forced a few weeks ago a specific query to use a specific plan. Now every now and then I have the error:
Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN
SET FORCEPLAN is passed automatically since the code executing that query doesn't.
So I would like to review my forced plan, maybe cancel it. But I can't find that query in the query store anymore.
Hence my question: is there a way to list all forced query plans and then how can I cancel one?