How to find a value or data column while tracing (SQL Profiler)

How to find a value or data column while tracing (SQL Profiler)

To find a value or data column while tracing

1. Create a trace by clicking the File menu and pointing to New and then Trace.
   
   
2. In the Connect to SQL Server dialog box, select the server to which you want to connect and a connection method.
   
   
3. To display data in the trace window, run SQL Query Analyzer, and then click the trace window in SQL Profiler again.
   
   
4. On the Edit menu, click Find.
   
   
5. In the Find dialog box, enter a search value or specify a data column.
   
   
6. Click Find Previous.

   The search starts at the beginning of the trace.

See Also

Monitoring with SQL Profiler