View executed queries

Hi all,

I would like to see which queries are beiing executed on a SQL server database. Additionally I want to see how much time a query takes.

For example, when I insert a record in a table with an insert-trigger, I want to see the insert statement and all the queries executed by the insert-trigger.

What can I do?

Thanks!

use SQL Server Profiler