In the Objects for Debugging window, tick the objects that you wish to trace and debug. In the Trace Mode column, select 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.