JN, did you ever find a satisfactory solution to this issue? I'm facing the same problem. The process of simple parametrization by the query optimizer is confounding my ability to audit ad hoc select queries in SSMS. I'm using Change Data Capture to track Inserts, Updates, and Deletes, but I've still not come up with a solution for auditing selects.