Replay to a Cursor (SQL Server Profiler)
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
This topic describes how to replay trace files or tables that pause when a cursor is reached by using SQL Server Profiler. 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
Make sure that the trace file or table you open contains the event classes necessary for replay. For more information, see Replay Requirements.
In the trace window, click an event.
On the Replay menu, click Run to Cursor, and then connect to the server where you want to replay the trace.
In the Replay Configuration dialog box, verify the settings, and then click OK.
The replay starts, pausing when the first cursor is reached.
Press F5 to resume the trace.
Repeat Step 5 through the end of the trace.