How to find a value or data column while tracing (SQL Profiler)
To find a value or data column while tracing
- Create a trace by clicking the File menu and pointing to New and then Trace.
- In the Connect to SQL Server dialog box, select the server to which you want to connect and a connection method.
- To display data in the trace window, run SQL Query Analyzer, and then click the trace window in SQL Profiler again.
- On the Edit menu, click Find.
- In the Find dialog box, enter a search value or specify a data column.
- Click Find Previous.
The search starts at the beginning of the trace.