Thanks G^2

But I've managed to work it out with BOL on sp_trace_setevent

I needed to track events SP:Starting and SP:Completed for calls by the application, and SQL:BatchStarting and SQL:BatchCompleted for calls from SSMS.