• Have you tried turning on profiler and running the procedure?

    Often enough - Profiler will capture the unencrypted version of the procedure. No fuss, no muss.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?