« Fixing orphaned SQL user accounts | Main
Wednesday
Aug182010

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.

References (1)

References allow you to track sources for this article, as well as articles that were written in response to this article.
  • Response
    We ran into some interesting migration issues while migrating our Oracle Cloud accounts around. We had a stand-alone Business Intelligence Cloud Service (BICS) account

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):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>