Another way to debug T-SQL stored procedures is to use SQL Server Profiler, a tool that allows you to monitor and capture the events and data that occur on a SQL Server instance.

Learn how to debug and optimize complex queries using SQL debugger, query profiler, query formatter, query generator, and query monitor.

To learn more about how to create and run traces, see Create Profiler traces for replay (Analysis Services). Use SQL Server Profiler to: Monitor the performance of an instance of the Analysis Services ...