replay-to-a-cursor-sql-server-profiler.md

title	Replay to a Cursor (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	replaying cursors traces [SQL Server], replaying replaying traces
ms.assetid	89eadc41-4424-4a1c-ba61-0b52c851cdb1
caps.latest.revision	22
author	JennieHubbard
ms.author	jhubbard
manager	jhubbard

Replay to a Cursor (SQL Server Profiler)

This topic describes how to replay trace files or tables that pause when a cursor is reached by using [!INCLUDEssSqlProfiler]. Pausing traces at cursors supports debugging because you can break the replay of long trace scripts into short segments that can be analyzed incrementally.

To replay to the cursor

1. Open the trace file or trace table you want to replay. For more information, see Open a Trace File (SQL Server Profiler) or Open a Trace Table (SQL Server Profiler).

   Make sure that the trace file or table you open contains the event classes necessary for replay. For more information, see Replay Requirements.

2. In the trace window, click an event.

3. On the Replay menu, click Run to Cursor, and then connect to the server where you want to replay the trace.

4. In the Replay Configuration dialog box, verify the settings, and then click OK.

   The replay starts, pausing when the first cursor is reached.

5. Press F5 to resume the trace.

6. Repeat Step 5 through the end of the trace.

See Also

Replay to a Breakpoint (SQL Server Profiler)
Replay Traces
SQL Server Profiler