SQLTeam.com | Weblogs | Forums

View executed queries


#1

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!


#2

use SQL Server Profiler