In profiler you may need to include RPC:Starting or RPC:Completed events. It will show dynamic query in TextData column like exec sp_executesql......etc.
Published under: SQL Server Tips · · · ·