Sqlserver exec sp_execute to simple query?
The application that you are profiling is using prepared statements. The SQL statements are being sent as sp_prepare @handle OUTPUT, params, 'T-SQL statement' before the calls to sp_execute are executed. You need to also capture the "SQL:Prepare" event in order to see what statements are being submitted. But I am not sure if you get to see the returned handle (i.e. the statement_id) that is then passed in as the first parameter to sp_execute (example: the 2 in exec sp_execute 2,...). The handle is per each Connection / Session, so handle of 2 for Session 53 is not necessarily the same as handle of 2 for Session 78. Meaning, you need to match the session_id / SPID between calls to sp_prepare and sp_execute.

Please see the following documentation:


sp_prepare
sp_execute