Hi!

I haven't tried this at all myself, but it might be worth a try: Check out the execution plan maintenance view, sys.dm_exec_cached_plans in BOL.

Also, server side trace (SQL Trace)...