Anybody know how I can list the prepared statements that are in a SQL Server instance?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
That above query will return all of the prepared plans that are cached, as well as their corresponding SQL text.