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

title	Find a Value or Data Column While Tracing
titleSuffix	SQL Server Profiler
description	Discover how to use SQL Server Profiler to search for a specific value or data column in trace output while the trace is running.
ms.service	sql
ms.reviewer
ms.subservice	profiler
ms.topic	conceptual
ms.assetid	fa5212af-1f49-4227-9d80-58003062146f
author	markingmyname
ms.author	maghan
ms.custom	seo-lt-2019
ms.date	03/01/2017

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

[!INCLUDE SQL Server]

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