I have an Enterprise Edition of SQL 2016 SP1, that has a database with Query Store active.
I want to search for a specific word or command in the saved queries. I have googled around and not seen anything. In this case I want to find 'SHRINK', but the same approach should be usable for any text in stored query.
Anticipating the "why?" comment. I have a vendor app that does a bunch of work and then shrinks the database and log files. I am trying to find the query that does it.
How to search Query Store for a specific word or command in a query?