ApexSQL Debug is add-in to SQL Server Management Studio. Offers step into, step out of, step through debugging with support for conditional break points, watches, call stacks and more. Lists the dependent objects called by the profiled procedure. User defined values can be set for procedure parameters prior to profiling.

T-SQL Debugger

• Initialize Debugging of a Stored Procedure 
• Stored Procedure Step Through 
• Mid Execution Call Stack 
• Defining Conditional Breakpoints 
• Lazy Debugging 
• Display Temp table contents 

T-SQL Performance Profiling

• Initializing Profiler on a Stored Procedure 
• Profiling Results 
• Profiling - Summary 
• Profiling Script View 
• Profiling Detail View 
• Profiling Variable/Parameter History