Database Reference
In-Depth Information
Figure 24-2.
The T-SQL_Replay template events and columns
This template is generic, so it includes the full list of events, including all the cursor events. You can edit it by
clicking boxes to deselect events; however, I do not recommend removing anything other than the cursor events,
if you're going to remove any.
I started this template connected to a test server instead of a production machine because once you've set it up
appropriately, you have to start the trace by clicking Run. I wouldn't do that on a production system. On a test system,
however, you can watch the screen to ensure you're getting the events you think you should. It will display the events,
as well as capture them to a file. When you're satisfied that it's correct, you can pause the trace. Next, click the File
menu and then select Export
➤
Script Trace Definition. Finally, select For SQL Server 2005 - 2014 (see Figure
24-3
).
Figure 24-3.
The menu selection to output the trace definition
