I reverse-engineered a script I found on MSDN to get the actual SQL statement/sproc from a SQL handle.
Note that the sqlhandle identifier is not passed as a literal.
This is very useful. I use this especially to retrieve sql statements from deadlock graph xml.
Glad you found it helpful!
Thanks for visiting.
Notify me of follow-up comments via email.