When use SQL Server Profiler, on the Events Selection tab, check Show all events; Find the Store Procedures event, check SP:StmtStarting and/or SP:StmtCompleted/... as you need.
SQL: See the TSQL underneath the sp_execute calls
原文：http://www.cnblogs.com/hellohelloworld/p/5018692.html