Grant Fritchey shows us how to use Extended Events to capture the T-SQL of a prepared statement:
Why would I be concerned with prepared statements? Wouldn’t sql_batch_completed and rpc_completed cover us? Well, no.
What happens when you use sp_prepare? What happens when you’re using an ORM tool that’s using prepared statements? You may see queries that look like this:
EXEC sp_execute 5, 48766;What the heck code is that executing? Let’s find out.
Read on for the code. It’s not the type of thing you want running 24/7 against all of your prepared statements (certainly not on a busy system!), but very useful for troubleshooting when you don’t have easy access to that next level up in the application chain.