SQL Server Profiler - View Dynamic Sql

Question

I am building and executing some dynamic sql and wanted to use SQL Server profiler to view that execution statement. Do you know what filters /settings I have to use in order to see that? I have looked through them and could be just looking right over the obvious setting.

EDIT:

The dynamic sql is called within a procedure.

Thanks in Advance,

--S

Answer 1

Following your edit you would need either the SP:StmtCompleted or SP:StmtStarting events (You can find these in the "Stored Procedures" section).

This might collect quite a lot of data so apply appropriate filters.

Answer 2

Take a look at the SQL:BatchCompleted event in the TSQL category and make sure you have the TextData column checked/shown. The Standard (default) template includes these already.