« Fixing orphaned SQL user accounts | Main

Get statement from sqlhandle

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.

Reader Comments (2)

This is very useful. I use this especially to retrieve sql statements from deadlock graph xml.

July 21, 2011 | Unregistered Commenteripad 2 keyboard

Glad you found it helpful!

Thanks for visiting.

September 9, 2011 | Registered CommenterTallarico

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>