Looking for documentation on how to create and run a custom query/report looking for any queries ran that contain a specific string. Our repository is in SQL Server.
You can try using the reporting in DPA to create something like in this description: DPA Report on Stored Proc Impacts
Just substitute in the string name for the SP name and it should find it in the SQL text. Just make sure it is unique enough so it won't pull in a lot of noise...
