Feature Only in Enterprise Edition This feature is supported only in Visual C++ Enterprise Edition. For more information, see Visual C++ Editions.
Once your SQL code has stopped at a breakpoint, you can step through the statements one statement at a time using the Step Into command.
To run the program and execute the next statement (Step Into)
The debugger executes the next statement, then pauses execution. If the next statement is a nested procedure, the debugger steps into that procedure and pauses execution at the beginning of the procedure.
If you use this technique to step into a nested stored procedure, the debugger steps into the most deeply nested function. For example, assume the next line of code is:
EXEC return = stored_procedure param1, param2
The Step Into command causes the debugger to step into the called procedure stored_procedure
and pause at the first line of execution.