find-a-value-or-data-column-while-tracing-sql-server-profiler.md

title	Find a Value or Data Column While Tracing (SQL Server Profiler) | Microsoft Docs
ms.custom
ms.date	03/01/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
helpviewer_keywords	searching while trace running traces [SQL Server], running traces [SQL Server], searching while trace running
ms.assetid	fa5212af-1f49-4227-9d80-58003062146f
caps.latest.revision	21
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

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 [!INCLUDEssSqlProfiler].

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