Find a Value or Data Column While Tracing (SQL Server Profiler)

This topic describes how to search for a specific value or data column in the trace output while the trace is running by using SQL Server Profiler.

To find a value or data column while running a trace

1. Click any row in the trace results while the trace is running.

2. On the Edit menu, click Find.

3. In theFind dialog box, enter a search value in the Find what text box and optionally specify a data column.

4. To find the next occurrence of a value, click Find Next.

5. To find the previous occurrence of a value, click Find Previous.

   The search starts at the row you selected in Step 1.

See Also

SQL Server Profiler
SQL Server Profiler Templates and Permissions