Walkthrough

Setting the Trace Mode

For each object marked for recording and debugging, the Trace Mode column value must be set. The trace mode can be one of the following:

• Variables – The object is traced; all parameter and variable values are recorded at every step.

• Temp tables – Parameter and variable values are recorded, as well as temporary tables before and after they are modified. This is available only in SQL Server 2005.

• Affected data – Parameter and variable values are recorded, as well as temporary and fixed tables before and after they are modified. This is available only in SQL Server 2005.

To set a trace mode for Multiple Objects, click on the Set Trace Mode toolbar dropdown and select the desired trace mode to be applied.