2. Focus Your Monitoring: Capturing Events from a Single Database in SQL Server Profiler
   Open SQL Server Profiler.Create a new trace or open an existing one.Go to the trace Properties (usually by right-clicking the trace and selecting Properties)
3. Demystifying Triggers: A Beginner's Guide to Monitoring Trigger Activity in SQL Server 2005
   Remember, when a statement triggers a trigger, the SQL statement itself and the trigger execution are considered a single unit by Profiler