SQL Server Profiler is the best tool to use. You can use respective filters as per your requirement. However just keep in mind that Profiler is resource consuming and avoided on production box.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."