SQL profiler not showing RPC calls
In the "Events Selection" tab of the trace definition, make sure that the TextData column is checked for RPC:Completed events.

(This is unchecked in the default trace definition)